m:n Relation

  • Thread starter Thread starter Jochen Stuempfig
  • Start date Start date
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
 
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
 
Back
Top