Hi, I'm trying to use one database to store customer info, and a second database to store records for each customer.
Let's call my first database 'Customers'. I have a form for the customers to fill out personal information. How do I make it that every entry will generate a unique ID since other keys such as name are not unique.
I want to link this to a second form and database, called 'Records'. I would have a separate form (that only I would access), where I can search for the specific customer I want to make a record for, and then this entry in 'Records' would be linked to the unique customer ID.
For example, in the second form, I would search John Smith as the name, and it would display in some drop down all John Smiths from Customers (along with some other fields to differentiate). I would select the John Smith I want to create a record for, and fields I fill in would be recorded in 'Records' for this customer.
How should I design this?