Main/Secondary Data Question

[JESwan]

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

 

[Sara Hopkins]

Hi JESwan,

I'm sure that someone else has posted it in this forum - I was looking for
it myself yesterday - but I can't find it now so I'll attach it...

MS Assistance has an article for it:
http://officeloc.iponet.net/en-us/assistance/HP010968321033.aspx

Sara

 

[Adam Harding]

Hi

I think i can explain it myself.

Add a Queryfield to your form as a text box and right-click it and select
change to DDlist box. Then populate your default values from your secondary
data source and then your query button will work like a dream.

Cheers Adam