Hello,
I don’t know if you guys are familiar with Access, but I’m in urgent need of some feedback so really anything is more than welcome.
I need to create a form that works with 4 different tables. It’s used for managing distributors. The schema could look like this:
The largest problem I have is to construct a SQL query depending on a field of some list (too feeded from database).
In this case, display cities only from the selected region so the SQL query for list of cities [COLOR=Red]could look like[/COLOR] SELECT * FROM cities WHERE [COLOR=Red]reg_id = [region_list.selectedItem.reg_id][/COLOR]
where the actual form should look like this:
I’ve never worked with this technology so I’m a bit lost in the ways these things should be done.
Thanks for your help,
Matthew