troubleshooting Question

Sub Drop Down in Table

Avatar of Sandesh555
Sandesh555Flag for India asked on
Microsoft AccessSQL
3 Comments1 Solution396 ViewsLast Modified:
Hi Team,

I am trying to create a table in such a way that I can have sub, sub drop downdowns.  For Example.  If I have a talbe with countries and their States and then again of the towns under those states.  I want to create the table in such a way that when I enter the State in the First feilds and go to the next one, I want the drop down to have only the states that belong to that country and then again when I go to the Towns list, I want only those towns that come up in the given state.

Please note, I know how to do the same using forms.  I want to achive the same on the table itself.

Thanks,
Sandesh.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros