How to manage relationship btw two tables

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.
 
E

Ed Robichaud

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to have two tables on same line? 1
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Avoiding Duplicate Entries 4
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Relationship setting 3
Table relationship design 2
Preserving input mask when using field in lookup for a second tabl 1
Trouble Creating Form 5

Top