AnsweredAssumed Answered

Auto-create record in related table

Question asked by JessicaKeyes on Apr 14, 2011
Latest reply on Apr 14, 2011 by JessicaKeyes

Title

Auto-create record in related table

Post

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?

Thanks!

Outcomes