Main Form & Sub Form

[jboyle]

I have a database that I’m building to ship product.

I have an inventory table that list all the details of each product in stock.

I have another table that is to list what carrier shipped the selected products. This table has a counter field to uniquely identify each shipment that is called Shipment ID.

What I am trying to do is to build a main form with a subform. The main form is where I select the carrier and I would like the subform to display all of the products in inventory. In the inventory table I have a “Yes/No” box to check if you want that particular item to ship with the selected carrier and selected shipment.

In other words, if there were 100 different products in stock, I want to be able to scroll down the list and click off on a check box for whichever products I want to go on a particular shipment.

I thought I could have a field in the products table called Shipment ID and use this to link the master/child fields. However, this is not working.

Any ideas would be greatly appreciated.

Thanks - John

 

[jboyle]

Thanks Pat, I looked at those databases and the way you select a product is to select it from a combo box. I need a form displaying every item in stock and let the user select whichever products he wants to ship on the order. I was hoping that when he clicks on the Yes/No, it would populate the order number to that particular item in the inventory table. Do you know how the could be acomplished?
Thanks John

 

[Angello Pimental]

John,

In the future could you please only post to one forum. As when you post to multiple forums you cause confusion, and its not proper forum edict.

Check your post in the general section for my reply to your problem.

Thanks,

Angelo