How do i do to check the same thing is not entered?Help!!

[xtrareal22]

Hi, i have two four tables.Invent,trans,newOrder and reorder tables.The new order table is not joined by a relationship unlike the others which are joined with the Invent ID field.
The new order table has the fields(ID,QTY,NAME,Order Date).I want to use this to order new items that are not in the Invent table.what do i do to check that i dont enter a new item name in the NAME field that is already present in the Invent table?Is it possible?

[June7]

You could use DLookup() function in code.

[xtrareal22]

can i do this using a macro since i dont know how to write a code??

[June7]

I don't use macros but I think they can use domain aggregate functions (DSum, DLookup, DAvg, etc).