SQL Select value from other table

[wtucker]

Hello everyone,



I have a form with multiple subforms and multiple tables. I have a field in Table1 that needs to pull a value from Table2 depending on the value of another field in Table1.

Table2 has a list of each U.S. state and a different Carrier value for each. I'm assuming I'd need to use a SQL command, like

SELECT Carrier FROM
State Carriers (table name)
WHERE State = [Client].[State];

Can someone help me piece this together?

[June7]

Thread already marked solved - is it?

No, SQL would not be like that.

Use real table names in your post narrative.

Suggest you use a combobox with RowSource from Table2 and then textboxes can reference columns of combobox. With combobox, save record ID from Table2.

Then build query that joins the tables on primary and foreign key fields.

[wtucker]

I thought I found the solution but it turned out to be a partial one.

Fields in the form:
Issue State
Carrier

Carriers Table:
State
Carrier

I have the combo box with the row source from the Carriers table. How can I reference the other column of the combo box in the text box?

[June7]

Reference the column by its Index. Index begins with 0. Column 2 has an Index of 1.

=comboboxname.Column(1)

Make sure the combobox ColumnCount, ColumnWidths, BoundColumn properties are correctly set.

[wtucker]

This worked great! Thank you!