I did do a search on the forums and couldn't find the solution to my problem, so sorry if it has been answered before.

In this example I have two tables, with related field Work Order #. The two tables are Work Orders and Invoices. When an order is complete, its Work Order # is added to the invoice table and an invoice is generated based on the Work Order info. An invoice can have multiple Work Orders on it, but these Work Orders MUST have the same PO#...

basically how do I validate the entry of the Work Order #s so that only Work Orders of the same PO# can be entered.

Heh, I hope that all made sense. Attached is a sample I've made.

Thanks in advance

portal_validation.zip

Edited February 19, 200718 yr by Guest
Removed Forum Info

I forgot to mention invoices has two layouts.

So basically I want it so that Orders 1 and 2 can be put on the same invoice since they have the same PO#, but Order 3 must be on its own seperate invoice.

figured it out myself :

put this in validate by calculation under the Work Order # field in invoices table:

If(Count(Work Order #s)>1;

If(Variance ( sample_workorders::PO # ) ≠ 0 ;False;True);

True)