Sub cell information in a table

[Avick]

I am not sure if this has been done in a table before. I have seen it in forms but not in tables.

Here is my problem.
I have created a database for a planespotters club. This database has the tables.
ac_logged
ac_maker
ac_model
country
airport

I am trying to display selected information in the ac_logged tbl that is related to other cells. For example: If someone selects boeing in the maker field they will only boeing models in the model field. Also, if someone enters Ireland in the country field only the airports for that country would be listed.

I don’t want to do this in a form but I could settle for a query if I have to.

I was just wondering if this could be done in a table as opposed to any other way.

Hope I have made myself clear on this one.

 

[ScottGem]

What you are talking about is cascading or synchronized combo boxes. these should ONLY be done on the form level, not on the table level. As a general rule ALL interaction should be done through forms. Users should NEVER see or access tables.

 

[ScottGem]

Thanks for the clarification, Pat.

 

[Avick]

Can this form be displayed in table view and accessed as such. Its quite important that they see more then one record at the same time.

 

[ScottGem]

Can this form be displayed in table view and accessed as such. Its quite important that they see more then one record at the same time.

Use a continuous form view.