Name linkage.

[emccalment]

So, I've got a table with info on personnel. It's got their social security number, last name, first name, and middle name. SSN is the primary key, but I'd like to be able to build forms so that when they enter data for other table entries, their first and last name auto-populate their SSN. (I'm betting against having name repeats in our office.)



Is this possible?

[pbaldy]

That's probably not a good bet, but you can certainly do it. You could use a DLookup() or open a recordset to find the SSN associated with the input names. I would code for the possibility of more than one match though.