S
Sean
Hello,
I have a many-to-many relationship like:
tblStores:
storeid
storename
tblProducts:
productid
productname
tblStock:
storeid
productid
quantity
I can create a subform showing for tblStock in the Stores form.
However, it will only show products for which an entry exists in
tblStock for the store. I want to show a list of all products whether
there is an entry in tblStock for that store-product or not.
Is there a simple way to do this?
Thanks,
Sean
I have a many-to-many relationship like:
tblStores:
storeid
storename
tblProducts:
productid
productname
tblStock:
storeid
productid
quantity
I can create a subform showing for tblStock in the Stores form.
However, it will only show products for which an entry exists in
tblStock for the store. I want to show a list of all products whether
there is an entry in tblStock for that store-product or not.
Is there a simple way to do this?
Thanks,
Sean