Let's assume you have a table YourTable: YourTableID, Field3, Field2, Field3, and a lookup table (don't confuse it with lookup field in table) LookupTable: LookupTableID, LookupValue. In your form based on YourTable you have a combo box with proprties ControlSource = Field3, RowSource = 'SELECT LookupTableID, LookupValue FROM LookupTable ORDER BY 2', BoundColumn = 1, ColumnCount = 2, and ColumnWidths = '0, 2.5'
In your form, in combo you select/see LookupValue's from LookupTable, but in YourTable, LookupTableID's are stored. When you want in e.g. query to see LookupValue's instead, the query must be like
Code:
SELECT yt.Field1, yt.Field2, lt.LookupValue FROM YourTable yt LEFT OUTER JOIN LookupTable lt ON lt.LookupableID = yt.Field3