August 10, 20169 yr I have a major table that I'm trying to integrate into a drop down menu option - get values from field but I need some help with this... The table has 3 fields, Year, Make and Model (Aircraft), so the values look like 1990 Cessna 180, 1990 Cessna 190, 1997 cessna 150, etc etc I'm trying to create a drop down wherein the user first selects the year (menu items calculated from the year field) then once a year is selected, only those makes from that year are shown, then model, only those models from that make is shown. Any suggestions greatly appreciated, thanks! Edited August 10, 20169 yr by Lee Smith ch alignment to left
August 10, 20169 yr What you are referring to is a conditional value list, or dwindling value list. Easiest would be to google it. There are many complete examples in the forums and on the blogs.
August 11, 20169 yr Steve is correct about many examples files out there, take a look at this site http://www.databasepros.com/list.php?search=conditional+value+list&submit=+Find+
Create an account or sign in to comment