G
Guest
I have two tables that I have created 1) Customers 2) Orders -- (the
customers table has a subform to another table, but all is well with the
'customers' form. When I pull up the customers form I have added a function
button that opens the 'Orders' form - when it opens, 2 fields on the 'Orders'
form are pulling from the input of the 'customers' form -- (which is what I
want) however, from that point, when I fill out the rest of the form to enter
an order for that customer, all saves EXCEPT for the cross-referenced fields
(and therefore I cannot look up the orders by customer once I save them) --
I've set the relationship between the tables by CustID (one to many) -- Not
sure what I'm doing wrong here --
Can anyone give me a clue ??
customers table has a subform to another table, but all is well with the
'customers' form. When I pull up the customers form I have added a function
button that opens the 'Orders' form - when it opens, 2 fields on the 'Orders'
form are pulling from the input of the 'customers' form -- (which is what I
want) however, from that point, when I fill out the rest of the form to enter
an order for that customer, all saves EXCEPT for the cross-referenced fields
(and therefore I cannot look up the orders by customer once I save them) --
I've set the relationship between the tables by CustID (one to many) -- Not
sure what I'm doing wrong here --
Can anyone give me a clue ??