C
cjoshua
I have a very simple "order form" Table that I want to not allow me t
enter Products (from "product information" table) or customers (fro
"account information" table) that are not already set up in thos
mentioned tables. What happens now is if the item or cusotmer ha
never been set up in one of the other tables, it just doesn't show u
when I run a query. I want a notification that somethign has "invalid
has been entered and/or want it not to allow me to enter th
item/customer in the first place with a warning message ie "customer I
# not valid" or "product number not found". How can I do this.
Thanks so much for any help
enter Products (from "product information" table) or customers (fro
"account information" table) that are not already set up in thos
mentioned tables. What happens now is if the item or cusotmer ha
never been set up in one of the other tables, it just doesn't show u
when I run a query. I want a notification that somethign has "invalid
has been entered and/or want it not to allow me to enter th
item/customer in the first place with a warning message ie "customer I
# not valid" or "product number not found". How can I do this.
Thanks so much for any help