Hello all,
I'm currently working on a form that shows product information. This is the problem I ran into:
The form uses data from two tables:
Table ProductLocations stores ProductName and ProductLocations. Products can be found at multiple locations.
Table Product stores ProductName and other kinds of product information.
Before you say, why two tables? Well, I`m working on a database which is already in use and I am not allowed to change existing tables.
I want the form to show only one record for one product, and I want to show the locations in a listbox if there are more then one of them for that particular product. I tried alot of things but somehow I keep getting multiple product entries if there is 1+ location. I have no clue what the problem is
I'm currently working on a form that shows product information. This is the problem I ran into:
The form uses data from two tables:
Table ProductLocations stores ProductName and ProductLocations. Products can be found at multiple locations.
Table Product stores ProductName and other kinds of product information.
Before you say, why two tables? Well, I`m working on a database which is already in use and I am not allowed to change existing tables.
I want the form to show only one record for one product, and I want to show the locations in a listbox if there are more then one of them for that particular product. I tried alot of things but somehow I keep getting multiple product entries if there is 1+ location. I have no clue what the problem is
