Hello everyone,
I have created following forms in my database based on the following tables.
frmSupplier (Main Form)
sfrmSupProduct (Subform1)
sfrmProductPrice (Subform2)
tblSupplier
SupplierID
SupplierCode
SupplierName
Address
Telephone
Fax
Mobile
ContactPerson
Email
Website
PaymentTerms
DeliveryTime
tblSupplierProduct
SupplierProductID
SupplierID
ProductID
ProductCode
ProductDescription
BrandID
Packing
UnitID
tblProductPrice
ProductPriceID
SupplierID
SupplierProductID
PriceDate
UnitPrice
tblSupplier referes to frmSupplier (Main Form), tblSupplierProduct refers to sfrmSupProduct (Subform1) and tblProductPrice refers to sfrmProductPrice (Subform2).
All related records are showing in the fields except in SupplierProductID (combo). The related products are showing in the combo list but not showing on the subform2.
Below is the RowSource of the combo.
SELECT tblSupplierProduct.SupplierProductID, tblSupplierProduct.ProductDescription
FROM tblSupplierProduct
WHERE (((tblSupplierProduct.SupplierID)=[Forms]![frmSupplier]![SupplierID]));