My apologies if this is a dumb question.
I have a table called "Tax Returns" and here are four items that need to be included in this table:
Tax Return Type
Tax Return Address
Each return can only have ONE tax return type and ONE tax return address BUT, the tax return address is dependent on the tax return type.
Each return type can be mailed to many different addresses depending on the RESIDENT STATE and if there is a refund or balance due on the return.
These items can be selected from a value list: Resident State and Tax Return Type
This item is just a logical field: Refund
How do I then limit the value list of Tax Return Addresses based on the above 3 items?
Any help greatly appreciated.