PhilModJunk - Continuation of the If script/function question from this morning.
So the Underground field auto-populates as needed, but I'm having trouble w/ the Permit Contact information. Since the tables are related, it's taken the first contact that matches the State field and auto-populates the fields in the Order table.
I need to fill those fields w/ records that match the state and city. I tried to set up the target field as a auto-enter calculation:
From the Orders table:
If ( OrderCity = PermitContacts::PermitContactCity & OrderState = PermitContacts::PermitContactState; GetField (
PermitContacts::PermitContactFullName ); "")
Of course, it doesn't work. I'm probably over thinking it again. I've tried to set up additional occurrences, but still couldn't get it to work.
Thanks for any help.