Multiple Value Lookup Fields Display (1 Viewer)

[nesco88]

Hello,

I'm working with three sets of data.

“ID 1” is the base data that is being looked up.
“ID 2” is the secondary data that references “ID 1”, with multiple value lookup enabled.
“Form Display” is exactly that – how the data shows up on a form.

We need the numbers on “Form Display” to be a display column, not the bound column. I have attached screenshots in a zip file.


Also, this can be presumably avoided by creating a middle-man table that links with two one-many joins instead of one many-many join. We’d like to avoid that method at this stage. Thank you!



Does anyone have a way around this? Thank you.

 

[static]

I looked at the images but couldn't understand. Please explain further. Ta.

 

[nesco88]

Hi static,

There are two tables: ID 1 and ID 2.



ID 2 references ID 1. Form pertains to ID 2.


k-part in Form Display needs to look like k-ID in ID 2.

 

[Minty]

I would have a look at this thread http://www.access-programmers.co.uk/forums/showthread.php?t=290491