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?