Linking location to companies

[Philip Wanless]

I'm working on a small database to track criminal cases by court location. We have 7 court locations, each with their own set of defence solicitors. In the main input form, i have fields for court location and defence firm. Both of these are based on tables. I want the court location chosen to dictate the choice of defence solicitors, so that users from one location cannot choose firms from another location (as they do not operate there). I suspect this can be done using the lookup wizard and a query, but I can't work it out.

Any help always appreciated.

Thanks

Philip

 

[MStef]

Hello Philip!

I think you need something like "DemoCourtSolicitorsA2000.mdb".
Look at Tablec, Forms, VBA, relationships.
Open "MainForm" and try.
Adapt it in your mdb.

 

[Philip Wanless]

Thanks

OK, that looks like it may work, thanks for the help MStef. I'll try it this afternoon.