Complex table relationships

[JString]

I have a table whos records are organized by a composite key of 3 ID's from 3
different tables. What is the best way to get the ID values from these 3
other tables and then update the fields in the original table whenever I
create a new record?

 

[Graham Mandeno]

Assuming you are creating the new records using a data entry form, put three
combo boxes on your form, bound to each if the foreign key ID fields, and
with a RowSource selected from each of the three other related tables.

For example:
Name: cboForeignKey1
ControlSource: ForeignKey1
RowSource: Select IDField, TextField from Table1 order by TextField;
ColumnCount: 2
BoundColumn: 1
ColumnWidths: 0

 

[Tom van Stiphout]

On Sat, 20 Sep 2008 07:46:00 -0700, JString

Have a form with three dropdowns. Each dropdown selects an ID and
Description from a related table.

-Tom.
Microsoft Access MVP