Hi, I am new to access but fluent in Filemaker. What I would like to do is have two tables, Customers and Customer info. They would both have customer ID fields and would be related through that field. I would like it to be the case that when I click new record in the customer table and enter a new customer ID it would create a new record in the customer info table and enter the customer ID from the the customer table into the customer id field in the customer info table.
This way when ever I create a new customer there will be a corresponding record for this customer in the customer info table.
Thanks for the help. let me know if you need more info.