I have a form called Clients that contains two multivalue listbox I can chose from the city list more than one city I need to show the districts on the other city that matches with the selected cities
I have a form called Clients that contains two multivalue listbox I can chose from the city list more than one city I need to show the districts on the other city that matches with the selected cities
This is not a good way. It requires a lot of code.
INSTEAD,
how about a single pick list in a listbox. User dbl-clicks from the list, which runs an append query, and puts this option in a 'pick list' table.
Items to pick FROM are in a source table,
items the user picks are put in the TARGET tPicked table
The query joins the tPicked table to the Data table.
NO CODING, just a few queries.
1 append query to add the user's pick
1 del query to erase only 1 selected item in the list
1 del query to erase all items in the list
ranman256
thank you for the idea, kindly do this to the attached file
your tables are not designed correctly using normalization.
you should have a sub table:
clientID, city