Dependant Information

  • Thread starter Thread starter Lee Pearce
  • Start date Start date
L

Lee Pearce

Guest
How Do You Do Dependant Fields?

Example being:

I have a list of Stores of which there are 4 Formats (Super, Extra, Metro, Express). Each of these formats have their own specific grades.

What i want to do is when entering a new store via a form, In the Format box i would choose one of the formats from a combo box then when i progress to the Grade Entry, i would only want to see the Grades for that particular Store Format.

Would i need to have different lookup tables for each of the format grades & how do i achieve the above?

Ive seen this done on Airline web sites, ie select outgoing airport then the destinations change to only those that can be reached by flights from the Outgoing airport.
 
search for cascading combo boxes in this forum; check sample databases too.
 

Users who are viewing this thread

Back
Top Bottom