A
Activo
Hello everybody
I am using Access 2003
DB setup
2 tables with a one to many relationship
2 forms each based on one of the tables
Problem
Customer info in table1, order info in table2. Form1 gets the appropriate
record for the customer, I need to be able to open form2 using a control on
the main form and the record should have the CustomerID of the current
customer inserted into the new record in table2.
How can I do this.
I tried synchronisation but it does not work, the result comes with a blank
CustomerID field in table2
Thanks in advance
Activo
I am using Access 2003
DB setup
2 tables with a one to many relationship
2 forms each based on one of the tables
Problem
Customer info in table1, order info in table2. Form1 gets the appropriate
record for the customer, I need to be able to open form2 using a control on
the main form and the record should have the CustomerID of the current
customer inserted into the new record in table2.
How can I do this.
I tried synchronisation but it does not work, the result comes with a blank
CustomerID field in table2
Thanks in advance
Activo