Using subforms for data entry

  • Thread starter Thread starter JeanetteJH
  • Start date Start date
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
 
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.
 
Back
Top