AnsweredAssumed Answered

item selection from drop down list

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

Hi,

 

I have 2 tables, Table 1 and Table 2.

 

Table 1:

PK: Date of Purchase

Status

 

Table 2:

PK: Date of Purchase (Link to Table 1)

Description

Remark

 

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?

Outcomes