Can you cross reference two columns of information

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have to lists of information on a table. When I need are the lists tied to gather, so that when "X" is selected from one list the corresponding match is auto-selected in the other list. This needs to work either way.

I think I could do this with a lot of Rules, but they would be a pain in the butt and be hard to maintain.

And for those that are thinking......if it's the same just put the information into on list? This is a request because half my company knows the half of the list and the other have knows the other half. So this is in effect trying to solve and argument of "which information is listed first" on one list.

I know....first world problems.

Photo of Jeff

Jeff

  • 10 Points

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,204 Points 20k badge 2x thumb
Easy to do with script!

Greek and Roman Gods ~ Add New Record
https://haversineconsulting.quickbase.com/db/bmaptsvrd?a=nwr

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=527

I love first world problems!
Photo of Jeff

Jeff

  • 10 Points
Dan, Thank you for your comment, but your answer is over my head of understanding of how it functions and how to implement it. I'm assuming there is a table(s) behind the scenes, but I don't see anything in the code that references the table(s). If there is not I'm really struggling. Can you break it down for me?
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,204 Points 20k badge 2x thumb
Instructions for using the IOL technique are here:

https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294