I have two datasets:

recordset1 which along with other information contains the index to
corresponding recordset2

I have set up a repeating region and need a field from recordset2 to display
with record1 data. I really have tried everything but there seems no way to
control which order cs3 puts the php code for the mysql read. I can easily put
in a list menu and cs3 will do the code to select recordset2 correctly but it's
a display and I am sure there is something simple I am missing and appreciate
in advance your time and advice.



I am running php 5 with mysql 5 on my IIS vista machine.