Validation Rule

[ritzzy]

Hello everybody!

I am trying to create a database in which to put all the invoices received from the suppliers.
For this I want to have the first table named "contracts". Here I want to register all the articles of the suppliers with their prices.
For the next tables in my database I want to use the articles from the first table and for the price field I want a validation rule which not allow me to enter another prices than those used in the first table.

Any idea is welcomed!

[ssanfu]

Look at this site:

http://office.microsoft.com/en-us/te...010142603.aspx

There are two templates that might help you:

Order management database
Customer Orders database