Matching Fields

[g@v]

Hi All,

Wondering if you can help I have a table called "example" which has field "a" "b" "c" "d"...

I then create another table called "importtable" with field "a" (imported in from Excel)...

I would then like to create a query which matches any and shows all the records which I imported in from Excel to my current table called "example" I looked at joining via "relationships" using a Select Query but it doesn't quite show what I'm after...

Should add I would like Field "a" in both tables to show but only if the number exists in the "importtable" if not then don't show..

Any tips

 

[lark_tilly]

Take a look at the attached db.
I believe the query is what you are looking for.