Show data of foreign key in a form

[Senate]

Hi


I'm completely new to Access and I could use a little help now
A have a form with some text boxes filled with data from a table. One of these text boxes contains a foreign key of another table. Now I want my form to display the data of the second table instead of the foreign key. How could I realize this?

[CJ_London]

easiest (and usual) way is to use a combo control

[NTC]

a form is bound to a record source (although there can be unbound forms also....) and you state that your form has data "from a table". that table is the record source of the form. but a query can also be the records source. So make a query that joins those 2 tables. change the Data source of the form from the table to the query; after you do that then all the fields of table 2 are available to you to drag onto the form.

[CJ_London]

not sure I agree - although does depend on what the form is used for, your suggesting is fine for a browsing form, but not for one to add or amend data - principle then is one form, one table. Start adding tables to get to the lookup data and you run the risk of the table becoming unupdateable - plus which field to update? the FK field you want to update or the data from the lookup table? Answer - lots of code to manage it