Hi all
I have several tables, an example is people with a location eg. London, Southampton, Cardiff etc. There are several people in each location. I want to produce a form with a combo box that looks up the locations, but I was wondering if there's a way of using a query to populate the combo box, which will look up the specific column in the table, but only list the unique values?
I have several tables, an example is people with a location eg. London, Southampton, Cardiff etc. There are several people in each location. I want to produce a form with a combo box that looks up the locations, but I was wondering if there's a way of using a query to populate the combo box, which will look up the specific column in the table, but only list the unique values?
