How to manage relationship btw two tables

  • Thread starter Thread starter Teosoma
  • Start date Start date
T

Teosoma

Hi folks.

A first table named ARTICLES contains the fields : ID (Primary Key) and
NAME. A second table named SALES contains the field : ID.

[SALES]![ID] and [ARTICLES]![ID] are bound by a Many-to-One
relationship.

How can i create a form where, when i gave the input : [SALES]![ID], it
shows automatically the output [ARTICLES]![NAME] for checking ?

Tx for your attention.
 
Look at the Access help and/or Northwind database for examples on using a
mainform/subform setup. It will do just what you need - show related
records in the linked subform for any record in the main form.
-Ed
 
Back
Top