PLEASE HELP with Query/Subreport problem

[IcePak]

Hi everyone,

I'm a standstill on this database at work. I can't go any further until I find out a way to do this.

I have a query thats finds one record (row) from a main table. The row is then displayed in a report. In this report I have a subreport. I want the subreport to have its record source be dependent on one cell of the previously queried (and report-displayed) row. This is necessary because there are 5 (smaller) tables that are applicable to different records in the main table. There is a field in the main table that says which of these 5 smaller tables is applicable to each record (row).

To give an example in case I'm not clear,

Field1 Field2 Field2
w1 blah blah1 Table1
w2 blah blah2 Table7

I just want information from the corresponding table to be the record source for my subreport.

ANYONE who knows how to do this or an alternative PLEASE PLEASE let me know

thanks
mike

 

[JerryDennison]

Why would you have tables that are dependent on or linked to a field? This does not fit the relational model at all. You will have to change the subform's recordsource property on the fly and all of the field names in the controls to match the table as well. Not a good design. Can you give us an idea of the field names in each of these tables?