Need help with relationshsips

Discussion created by jjfcpa on Jul 31, 2014
Latest reply on Jul 31, 2014 by jjfcpa

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:


Resident State


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.