Lookup Field

[thomasknebel]

Hi,

I want to create a lookup field for looking up from a table which itself contains foreign keys but not the values it relates to. Said that I don't want to lookup the foreign keys only but the values the foreign keys are related to in a third table.

Thank you,

Thomas

 

[GinaWhipp]

Use a Combo Box and when setting the Column Widths set the first one to 0 (zero), that way the Foreign Key will be hidden.

 

[thomasknebel]

Thank you GinaWhipp for your reply!

My apologise as I have been inarticulate in my explanation.

Table 1 (ComboBox) -> Table 2 ID (only) -> Table 3 Name related to ID

I would like to lookup information from two tables.

Thank you,

Thomas

 

[Minty]

Create a query that links your Data and use that as the combo box rowsource.

 

[thomasknebel]

Minty,

allow me a follow up. I did as you proposed, created a query with the fields I would like to include in the lookup. But then I needed to delete the relationship between the tables. Of course the right value will be used but there is no actual relationship between the tables any more!

Or I am wrong? ...and if not how to solve?

All the best,

Thomas

 

[Minty]

You can create any relationship (Join) you want in a query to get the desired results. The stored relationships are only there to assist the wizards, and enforce referential integrity if you use that functionality.