Trying to Link tables

[brandonze]

Hello all,

I am still new to access and need a little help to do something that is probally really simple.

I have a table that contains all the information that I need for my event. The data that is important for this question is the Last Name, First Name, Rank and SSN.

What I want to do is to be able to put the SSN into an access table via a barcode reader. This is not the problem. the problem is that after I input the SSN, I would like the Last Name and First Name and Rank to populate on the table that the SSN is scaned into.

Any help would be better than what I have know.

Thanks
~Brandon

[pkstormy]

You'll most likely need to design a form (and update query), where the user selects the ID (ie. autonumber field) for getting the name info.

To do it on a form, have 2 comboboxes, one which selects the ID (from the name table) - the rowsource of this combobox will also have first name, last name, etc.. fields, and the other combobox which selects the SSN. Then design an update query against the table which has SSN, setting the criteria of SSN to =Forms!MyFormName!SSNField for the criteria row under SSN,
In the update row, you'll have expressions such as: Forms!MyFormName!IDCombobox.column(x) where x is the appropriate column for the combobox (ie. x=1 for first name, x=2 for last name field. Then double-check to make sure these are also the correct columns for the combobox.