Hi, Franca.
There are a couple of strategies, depending on what you want to do
specifically. One approach is to create a query joining the tables together
by their keys, and selecting the fields you'd like to display. Note,
however, that some queries are not updatable. Search for "non-updatable
query" to read the specifics.
A second way is to display fields in textboxes by referring to the Column
property of a combobox. Let's say you have a form based on an Orders table,
and the customer is inputted via a multi-column combo box. In the Orders
table, you will store the customer number as the foreign key. If you'd like
to display the customer's address, phone number, and other fields from the
Customers table, include them as columns in the textbox. Then for each
textbox, set the Control Source to = YourComboBoxName.Column(Index), where
index is the column #, beginning with zero for the 1st column.
A third way, useful for displaying a one-to-many relationship such as Order
Details, is to insert a continuous subform on the main form, linking the two
by the foreign key, in this example, the Order Number. To do this, create
both forms, open the main form in Design View, and drag the subform from the
Forms tab of the Database window onto the main form. If wizards are enabled,
you will be prompted to indicate which field in each form Record Source is
the linking field. If wizards are disabled, you can set this manually by
altering the Link Master Field and Link Child Field properties of the subform
control.
Hope that gets you started. If none of these seem to fit your specific
situation, post more detail about what you're trying to do, and I'll try
again.
Sprinks
