m:n Relation

J

Jochen Stuempfig

Hello,

is there a way to check if an masterdataset has an entry in an m:n relation
table?

for example:

i have three tables: Customer, Buildings and the m:n Relation
Customer_Building
what i want is that i can get all customers there already not stored in the
relation table for the corresponding building.

greets

Jochen Stuempfig
 
M

Michel Walsh

Hi,


Run the query Wizard about finding unmatched records: you want to find
records in Customer without matching records in Customer_Building.


Hoping it may help,
Vanderghast, Access MVP
 
Top