Limit values of Field

[Jean Pradelle]

Hello,
New to Access have been strugling w. this one for some
time now.

I would like to know how to limit the values of
SubtypeClient in Table1 to these w. associated with the
corresponding TypeClient defined in table 3 (in this
case; Coffee shop, Gifts, Tableware)?

Table1
Company TypeClient SubTypeClient
Abracadabra Shop ????
(list from Table2)

Table 2
TypeClient
Shop
Dept. Store
Press

Table 3
TypeClient SubTypeClient
Shop Tableware
Shop Gifts
Shop Coffee shop
Press Fashion
Press House
Thanks. Jean

 

[Jeff Boyce]

Jean

Rather than limiting one table's values to another's (and you really want to
be using an ID field, not the actual "text" value), how 'bout working in
forms, rather than tables.

Tables are great for storing data, but very poor for controlling events.
Forms, on the other hand...