medical database, display previous visit info when entering data for a new visit
I'm new to FM but I hope to learn it fast with your help...
I am creating a database to manage patients. Patients' contact info are in a table, and to simplify, the visits information are listed in another table, linked in a one to many way.
One patient will have many visits over time, and I need to figure out a way, when entering data for a visit, to display certain information from the previous visit, and also to be able to copy/paste info from one visit to another...
(I'd guess the same thinking may be already used when generating new invoices for the same customer using previous invoice info...)
Any thoughts? Thanks in advance, guys!