How to handle indirectly related data

  • Thread starter Thread starter mscertified
  • Start date Start date
M

mscertified

My main data table (tblProblem) has a related table that contains keywords
(tblKeywords). Each row in the data table can refer to zero or more keywords.
Each keyword may require zero or more extra data input items. The data items
required are stored in a table (tblDataItems) related to the keywords. When
editing my main table, I need to display and allow entry/update of these
extra data items. I cannot do this via a subform since there is no direct
relationship between the main table and the data items.
So it seems I have 2 choices: dynamically create an input form for the extra
data items as the main record is accessed OR create a directly related table
and populate it as the keywords are selected - and show the results in a
subform. Which design is the best approach?
 
Presumably you alreeady have the three tables linked in "daisy chain:
fashion, why no just make the recordsource of your subform be a a query which
joins Keywords and dataitems and displays the dataitems

If I understand your situation, you should be able to do this by making the
recordsource of the subform be a query which contains/joins your Keywords and
DataItems tables.
 
Back
Top