Using subforms for data entry

J

JeanetteJH

I have an inventory database that works fine except I can't seem to get this
problem figured out. I have a Purchase Order Table and an Inventory
Transaction Table that I want to combine into a data entry form. I want to be
able to fill out and print a Purchase Order on this form. I can create the
form and the subform, but I am getting confused on why I can't enter more
than one item to order on the subform. I assume that they aren't linked
correctly, but I am not sure what I am doing wrong. The order data shows up
correctly on the subform if I enter the order info into the table, but I want
to be able to enter it directly into the PO form and then print the PO.
Thanks for any assistance.
Jeanette
 
K

KARL DEWEY

Your Purchase Order Table should be set as one-to-many relationship to the
Inventory Transaction Table. Then the form/subform Master/Child links need
to be set using the fields of the Purchase Order Table and the Inventory
Transaction Table the set the relationship.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top