Hi hoping someone can help me. I'm stuck. Here are the match fields:

Match Fields: Customer::Invoice ID match to Invoice::Invoice ID

Invoice::Order Num match to Order::Order Num

Order::Order Num match to Elec::Order Num

Order::Order Num match to Parts::Order Num

The problem is in the Orders to Elec. and Orders to Parts tables. Once Order Num is created, it uses the same Order Num for both Elec. and Parts and if I have two or more entries for either tables (Elec and Parts) it uses the same Order Num. I can create different Order Nums for one Customer but only one (the first) is being used when I create records in Elec and Parts. It should be a specific Order Num = specific Parts ID or specific Order Num = specific Elec ID.

Thanks a lot for anyone who can help.

Jean

Can you attach your files? How you create records in Elec and Parts? By Portal or ....?

aaa, when you mentioned portals I got to thinking that maybe where the problem is coming from. I had 2 portals in one layout. I was trying to make something work between those two portals in that layout. Portal 2 wasn't recognizing portal 1 as the source table which is correct.

I broke them up where I made a new layout where Portal 1 is now the source table for the layout and Portal 2 is now the sole portal. And it worked!

Thanks!