I have seen this question for older versions and for use on forms, let me
throw my twist into this. I have a table called student list with lname,
first name, grade, student id. I have a second table that records student
parking stickers and parking violations called action list. there are linked
by a one to many relationship by student id. I created a simple form from
studnet list that shows the fields for the action file table below it. My use
will enter data directly to the fiedls there not thru a form. (he likes
that). My question when I ge to the filed make I would like to select Ford,
Chevy etc. then have the Model filed only show the appropriate models. Can I
do this directly in the table design mode? I do not want a form or query if
possible. Also I assume I will need to creat a new table with make model in
it? Thank you hope I am clear.