SUBDATASHEETS

[geeves1293]

I have got two tables which are related.

The first has is an Orders Table.

The second, an Orders Detail Table.

Can I create a select query showing me the Orders which have no link to
Order Details. Basically Orders with no detail.

Thanks

Geeves1293

 

[Allen Browne]

When you create a new query, the first dialog gives you the choice of:
Unmatched Query Wizard

Use the Wiz. to create the query for you.

 

[geeves1293]

So simple when you know how.

Thanks very much for your help.

geeves1293