list and multiple tables

[sds814]

I have 4 tables each one having it's own dataset. I have to repeat these 4 tables for eight companies. I want to create a multiselect drop down list and have the 4 tables in a list so the tables will be repeated for the companies chosen.

So the results I want is:

Company 1

Table 1
Table 2
Table 3
Table 4

Company 2

Table 1
Table 2
Table 3
Table 4

I set the list dataset to Company Name and cut and paste one of the tables in the list. I got an error that summed up to that the table cannot have a different dataset then the list.

Any suggestions?

 

[xlbo]

Correct - you cannot have more than 1 dataset associated with a list

If you want to do this, you will need to alter your SQL to bring all data down in 1 recordset

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question