DEFINING RELATIONSHIP BETWEEN TWO or more TABLES

P

pago_boss

I am often required to design queries involving two or more tables and
linking them together. However, in linking them together, i am often
forced to define the relationship (join properties) between these
tables and I often get it wrong. As a result, i get duplicate records
all the time. Can anyone explain to me how does one-to-many and many-
to-many relationship really works in Access queries and how are they
being retrieved. And how can i easily identify and fix this probem.

Plese give some examples.

Thanks,

Pago
 
S

scubadiver

Go to tools -> relationships, display the tables then drag the appropriate
fields between tables to establish the relationship.

When you set show the tables in the query the relationships will show. But
remember the tables will only show as many records as the two tables have
recorded (if that makes sense)
 

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

Adding data to MS Access from csv file 0
linking tables and relationships 3
Understanding Many-to-Many Relationship 4
Relationships for queries 3
Defining relationships in Access 2
Linked SQL Tables don't report Cascading Updates and Deletes 2
Complicated relationship between two tables 2
Where should I define relationships for external tables? 1

Top