Auto-create record in related table
I know this has been discussed, but I'm very new to FM and I haven't been able to figure out how to solve my problem.
I have a very simple database for a veterinary ultrasound business. Table 1 contains individual records for each scan that has been performed. Table 2 contains the names, species, and breeds of the patients with portals to show the important data from Table 1 (some patients have multiple scans, but most do not). I'm doing the bulk of my data entry into Table 1, and I want it to automatically create new patient records in Table 2 when I put someone new into Table 1. What is the best way to do this?
Also, I've seen a lot of posters referring to record IDs, and I understand that this is a number that can be automatically generated. Is this necessary? What do you miss out on if you don't create record IDs?