I have 2 tables, Table 1 and Table 2.
PK: Date of Purchase
PK: Date of Purchase (Link to Table 1)
I was able to use the Drop down list on Table 2 "Date of Purchase" to select Table 1's "Date of Purchase" items. Howeer, I need to filter this list with the Table 1 "Status".
Example, only items that has a Status "NEW"in Table 1 will be displayed (Date of Purchase will be disaplyed and available for selection) in the drop down list in Table 2.
How do I do that?