Setting 2nd Filter Based on 1st Filter

[Charles_FMCC]

I have 2 tables, Table A and Table B.  I have a selection filter for date on Table A.  I have a straight table based on Table A and want to add a straight based on Table B = Table A date.  I tried the following as an example and have not been able to get the second table to populate or it does not filter.

No results saying calculation condition unfulfilled:

vTableA_EFF = TableA.EFF_DT

TableB.EFF_DT = $(vTableA_EFF)

Second attempt shows all records in Table B:

TableB.EFF_DT = $(TableA.EFF_DT)

Any insight into what would be a good way to make this happen.  I am unable to use macros due to company constraints.

[stevejoyce]

Not sure how those variables are being used, your set analysis?

You can make your expressions use for example:  Sum({<TableB.EFF_DT=P(TableA.EFF_DT)>}  Measure)

[Charles_FMCC]

Basically I select a date in a List box for Table A and generate a straight table based on it.  Without having to add a second date List box for Table B, I want to add another straight table base on Table B and the same date.