My application has two tables. The first table consists of a list of products with a unique ID and one column indicating which store they are in. The second table is for sale. It specifies the date, seller ID, and store ID. A third table, Sales Details, is related with this table. This table contains the product, quantity, price, and here I have a problem. When I want to select a product, a list of all products will drop down. And I need the drop-down list to contain the products of this particular store, which has already been selected in the second table. And these tables are connected through sales id. What formula and how should I use so that I can see only those products that are in the selected store?
LinkedIn
Twitter
