AnsweredAssumed Answered

DropDown populated by multiple (joined) tables

Question asked by TroyKelly on Aug 19, 2011
Latest reply on Aug 22, 2011 by philmodjunk

Title

DropDown populated by multiple (joined) tables

Post

I need to populate a DropDown with an inteliable list of options.

It is super clear / easy to populate it from a single table, but I need data from three tables.

Ultimatly I need tblFlyLines::ID but the user needs to be presented with a concatenation of 

tblFlyPositions::Identifier & "-" & tblRiggersPosDSUS::Identifier & tblRiggersPosPOP::Identifier

I have tried creating a "Query" type table that has a calulated field with the above content - but - if any of those tables are changed - the "Query" table is not updated.  The dropdown really should be generated on the fly - to prevent storing data that could (and should) be calculated.

Any advice / recomendations would be really apprecaited.

Screen_Shot_2011-08-20_at_3.39.21_PM.png

Outcomes