Auto Populating using multiple tables.

[Huddle]

In the attached database I have a donation form that I want to be able to enter the first and last name and donation information but I get a need for a primary key error which I am assuming is the D_Code. I did a Me! after update code off of the first name combo box to populate the D_Code but am getting a error that it can't be populated. I am assuming that it is because it is from a different table. Can you please tell me how I can accomplish what I am trying to do?

[June7]

You have not defined primary key field in Tbl_Contacts. C_Code is a poor unique identifier. What if you have more than one Jane Smith? Should set ID as primary key.

Forms can do data entry/edit for only one table. The form RecordSource should not include Tbl_Contacts.

Should not have two comboboxes for selecting contact, should be one combobox and should not be bound to fields from Tbl_Contacts. Set combobox properties:

ControlSource: need a number field in Tbl_Donations for saving Tbl_Contacts ID
RowSource: SELECT ID, C_Last_Name & ", " & C_First_Name AS FullName FROM Tbl_Contacts ORDER BY C_Last_Name, C_First_Name;
BoundColumn: 0
ColumnCount: 2
ColumnWidths: 0";2.0"

Alternative is a form/subform arrangement. Main form bound to Tbl_Contacts and subform bound to Tbl_Donations - no combobox needed.

[Huddle]

Looks like the subform idea works best for me. Thanks.