propogate fields from combo box

[jacque_56]

This is probably a very basic question, and direction to how to get it done would be greatly appreciated.

I have a form with a combo box that selects a students ID number from the students information table.

Combo box includes
ID
First_Name
Last_Name

It lists on the form First and Last Name and it records on the new table (Scholarships) ID Number.

First and Last Name are also fields in the SCholarships table and I would like to have them filled when I select the item in the combo box.

Similar to Order Form, select customer number fills in name, address etc.

I don't know how to make this happen. I have relationships between all three fields in both tables.

HELP

 

[Mile-O]

You've got the wrong idea.

Firstly, you'll want to change that field called ID to StudentID. (Autonumber) Maybe even change First_Name to FirstName and Last_Name to LastName - it aids the process and reduces errors going forward with your design.

Secondly, you'll want to remove those First Name and Last name fields from the Scholarships table. Replace them with one numerical field called StudentID.

Now, your combobox should have three fields: StudentID, FirstName, LastName. The column (Column 0) with the StudentID should be the Bound Column and be bound to the StudentID field of your scholarships table. The two columns for the first and last name can actually be concatenated to make it look even better in the combos's RowSource property.

I'm not going to go into how to normalise a table but you'd do worse than to search this forum - and Google - for normalisation and understanding the 1st, 2nd, and 3rd Normal Form of database design. (1NF, 2NF, and 3NF.) Since I spotted the _ in the field names you may also want to look up naming conventions too.