I have 3 tables. Products, prices and stores.
Products Table
————-
idProducts ProductName fkCategory
Prices Table
————
idPrices fkProductID fkStore Price PriceDate
Stores Table
———
StoreID StoreName
How can I update these related table through a form? I am trying to implement DropDown boxes from each table ; for example displayMember: ‘ProductName’,
valueMember: ‘idProducts’ but how can I create a second DropDown and load data from Stores Tables like before? example I need another DropDown that loads the StoresID and StoreName so when I click it will submit the “valueMember”.
I hope you understand the situation… is there any other way to update the data? thanks…