On Wed, 10 Mar 2010 08:29:02 -0800, tonkaplayer
wrote:

Can I do this directly in the table design mode?

No.

I do not want a form or query if possible.

"I have a car, but I do not want to use the transmission or the steering gear
if possible, just the engine".

Queries are the backbone of any relational database application. Forms are the
user interface for working with data. you can use a Datasheet view form, or a
continuous form made to look like a datasheet, if your user prefers that look,
but Tables simply don't have any usable events for this purpose. They are
designed for data storage, not for data interaction.
--

John W. Vinson [MVP]