selecting attrebuts that are not matched (1 Viewer)

[Neil.Cranston]

I have two tables, one holds the connections and another holds the hardware.
The Hardware is linked together by connections.
I have created a query including both these tables and want to be able to select
the connections that have not been used in the hardware table. So that I can add new connections, from the connection table into the hardware table without any connection duplications.
I intent to select the connections from a combo box on a form.

any one got an Idea how to do this.

Neil Cranston

 

[Ron Bell]

in query design
tbl1 link 1-many to tbl2

add tbl2's linked id to design then
criteria where = is null

then y should have only in tbl1 those that are not in tbl2