Showing related data in a form

[junestag]

I'm wondering if its possible to enter data in a form that populates 1 table but also SHOWS data from a related table (from a table already related to the underlying table of the form via another field) on another part of the form - say a 'sidebar'?



Thus for example I have two ID fields in my related table and I want to be able to select/enter data for one of those ID fields in my form and have the other, related ID field show up somewhere on the form AS I'm entering the rest of the data for the record.

[June7]

Options in order of preference:

1. a multi-column combobox, properties:
RowSource: SELECT [id field], [other id field] FROM tablename;
BoundColumn: 1
ColumnCount: 2
ColumnWidths: 0";1.0" (if you want to hide the first id so users make choice with the other id)

2. form RecordSource is a query or sql statement that joins the tables with join type: "Include all records from {tablename} and only those from related {tablename} that match"
Bind textbox to the type field from table2 and set it Locked Yes, TabStop No

3. DLookup function expression in textbox ControlSource

[junestag]

Thank you a second time!