AnsweredAssumed Answered

item selection from drop down list

Question asked by fmk4 on Jul 29, 2012
Latest reply on Jul 29, 2012 by techt



I have 2 tables, Table 1 and Table 2.


Table 1:

PK: Date of Purchase



Table 2:

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?