Autofill Fields based on related table

[rkass068]

Hi, before people start saying there are tonnes of threads on this I want to explain what I want to do. I am making a database for a bunch of doctors and I have 3 tables 

 

1. Main table KF: pk_main

2. Insurance Contact: KF: pk_Insurancecontact Child:fk_main fk_insurancecompany

3. Insurance Company KF:pk_Insurance company

 

Main------>Insurance Contact<--------Insurance Company

 

Now I have already implemented autofill of the address phone number etc based on pk_insurance company and it works great but, I want to implement a second criteria to autofill the this information. 

 

Each patient can have multiple insurances. If I make a new record in the insurance contact, I want to select the name of the insurance company and then I want to select the branch number. Based on the branch number and Name of the company I want the address, phone number, city etc to autofill. I know I can make another table to relate to the insurance company with multiple branch numbers etc. But I cannot seem to get it to autofill. Can anyone help me? 

 

Thanks

[Matthew F]

Are you trying to copy data from one table over to the other?  If so then I imagine that you want to set a script trigger to fire when the insurance company ID number changes for a patient.  

 

Can different patients have different Insurance contact info for the same companies?  If so, then dedicated fields for this should be on each patient's insurance record.  If not, and you want to display consistent/current insurance company information across all contacts, then you could simply display related fields, from the insurance company table.