Multi_valued Field Row Source SYntax

[bucrepus]

I have simplified this for display sake.



I have 2 tables with text fields

Table 1 has 3 fields and 2 rows

DEVICE| DISPLAY1 | DISPLAY2
_______________________________
A | A1 | A2
B | B1 | B2


Table 2 has 2 fields, but the second is a multi-value field

DEVICE | MDISPLAY
_____________________________
A | **MUTI-VALUE** based off the table 1

In the row source of the Multi-value Field MDISPLAY, I have

Select DISPLAY1, DISPLAY2 from TABLE1

The problem. I can get the MDISPLAY field to display the items from Table 1, but it grabs ALL of them.
I need it to display ONLY the DISPLAY1 and 2 field associated with the value of the DEVICE for the current row in table 2, which is 'A'

SO if I look at the row of the table 2 that has the device 'A', the MDISPLAY field for that row should have
Just A1 and A2, NOT A1,A2,B1,B2(all the rows).

I can't figure out how to access / syntax of the current value of the DEVICE field in my row source..

Select DISPLAY1, DISPLAY2 from TABLE1 where table1.Device = Table2.device /or Device ... etc.. 'doesn't work


Any Ideas
Thanks,
Buc

[June7]

I NEVER use multi-value fields.

Data structure makes no sense. Why is Display saved in both tables? Why do you have 2 tables with essentially the same data?