Hi,
My form uses a role based rule upon opening to query the database, thu
limiting the dataset size to only those items of interest to that use
role.
The user is first confronted with a repeating table which furthe
filters the data to show a  list of open items for that specific use
(based on a username field).
My goal is to allow the user to select an item in the repeating tabl
by clicking a check box in the relevant row, a check box rule is the
used to grab the primary key: "@ReqID" for that line and store it fo
later use in an nonrepeating field "my:/ID". Next the user must a clic
the "Details" button which uses a rule to set the @ReqID value in th
queryFields datasource equal to the value in "my:/ID", and then requer
the database to return only that entry. The view should then change t
show additional detail(fields) within the same table - but for th
selected record only.
I have set this up, but the query does not work as intended, Every ite
in the database is returned, instead of just the selected one.
The problem I believe is in using the button rules to set th
queryField @ReqID value. It is apparently remaining null and no
accepting the desired value
Any ideas as to what I'm doing wrong, or perhaps a better way to d
it.
Thanks