Auto-populating table field

[nomad]

Hello,



I know auto-populating has been asked before for forms, but I am looking to auto-populate a couple of fields in a table based on an ID Number that corresponds to another table. I realize it is not the best practice to duplicate data in a DB, however, I am using an ID card program that requires tables to populate the ID card information. My hope is to have two separate tables for 2 versions of ID cards.

The first table is called Firefighter info with fields of ID Number, First Name, Last Name, and Firefight Certs, EMS Certs, and emergency contact information. The second table is called EMS Personnel with fields of ID Number, First Name, Last Name, EMS Certs, and other fields that will be entered manually. I would like the First Name, Last Name, and EMS Certs fields to auto-populate in the EMS Personnel table when the ID Number is entered. I have a relationship already listed between the two table that links the ID Numbers in both.

The Firefighter Info contains the information for all members of the department, regardless of whether they are EMS, or strictly firefighters. The EMS personnel table contains information strictly regarding to the EMS members. Thus, the ID number you are entering into the EMS table will always correspond to an existing entry in the Firefighter Info table.

First off, is this possible? Secondly, if it is possible, could you offer some guidance on how to accomplish this?

Your help is greatly appreciated!!!

-Chris

[pbaldy]

I wouldn't store the info other than the ID, and I'm doubtful about having 2 tables, but

BaldyWeb - Autofill

[nomad]

Normally, I wouldn't either, however the program that is interfacing with the database requires the information to be present in a table, and I do not want to include all the information in a large table, because many of the fields are only required for 50% of the records. I would rather have this data stored separately from the main table.

This is geared more to forms. Is there anyway to accomplish this task with just data input in the table? I was hoping to just perform data entry through the tables, and not forms, as I will be the sole user of the system.

Thanks,
Chris

[pbaldy]

To my knowledge it can't be done in a table.

[nomad]

Okay. Very good. I will take the forms route. Thank you for your time!

[pbaldy]

No problem, and welcome to the site by the way!

[nomad]

Thanks! This is a really great resource! I am not too experienced with databases. I've only taken one college course at the local community college on basic database structure focused on Access. Certainly a lot to learn, but there's no better way than diving right in with a large project. Forums like this will certainly help me along.