I have created a Tracking System DB for WorkmenComp Patients unisg Access 2003. I have several different headings like Physician, Employer & Adjuster. Within these headings I have fields like: Name, Address, Phone, etc.
1 - If i have a Patient that uses the same Adjuster as another Patient. How can I pull up the Adjuster information automatically. In other words, I don't want to fill in the Adjuster information if he already exist in the DB. Please Advise. Some instructions will be helpful.