Newbie If...Then question...please help

[rbemiller]

I have a form in which the user selects the Sales Order number, then all other fields are populated based on that number. Among those fields are info for customers' address. The Issue: I have a shipping table and a billing table, if there is address info in the shipping table, the form needs to be populated w/ the shipping table info, otherwise, it needs to be populated with the address info from the billing table...which would always have address info.
Can anyone help me with the If... Then code I would need for this?

 

[cpod]

In the query that your form is based on enter something like this in a new field:

CustAddress:iif([shippingaddressfield] is null,[billingaddressfield],[shippingaddressfield])

You then reference CustAddress in your form.

 

[rbemiller]

I appreciate your reply Pat, but the problem is that I'm pulling all of the info for my application from a 1/2 Million dollar software package, and thus it is not feasible or even possible for me to change something within that system. The more likely scenario is that I've probably been pointed in the wrong direction for this shipping info. This is an extremely sofisticated system, and I'm sure they've got good table structure. It's just that I don't know where to look for it. But, enough about me...