Recent content by LCaddell

So my table would look like like this: *Billing # | Date | Initials | Comments with billing # being my primary key. Correct? Then when I pull a query it will grab all the notes for a specific patient based on the billing number, because that is the relationship between all my sheets...

Next question. If I use the Billing # (which uniquely identifies my patient) and create just one table for comments, couldnt I just have multiple records using the same billing ID? For instance: Billing ID: 123 Review Date: 02-28-2012 Initials: ABC Comments: Called insurance company NEW RECORD...

I am creating a database to house patient information and there is a need for an insurance review screen where multiple people can add comments. The problem is I want each individual occurrence to be its own. For instance: 02-28-2012 ABC Called insurance company 02-28-2012 XYZ Faxed clinical...