For the Main Source I understand the Query and Data Fields ok.
I enter a Prov ID number in a text box select query to return all the
appropriate Mem records for the Prov ID.. Good enough...

I want to replace the text box with a DDList of Text Values, not the ID value.
I am trying to assign the Text value in the DDList, and have the ID Value
used to populate the Member table in the repeating section.

Here is what I have, a ProvMem table that links multiple Members to a
ProviderID

ProvMem       Prov          Mem
1    99           1 DrX        99 Jones
1    89           1 DrX        89 Smith
2    77           2 DrY        77 Doe

I need to populate a DD List with the Prov Name (DRX) and have the same Mem
records display, going through the ProvMem assignment table.
I built a secondary datasource and selected only the Prov ID and Prov Name,
and am trying to assign the ID and Name to the DD List, no luck.

Seems simle enough but having problems.

Anyone have a good site that explains how to accomplish this.

Thansk, J