M
Mike
I didn't think I was trying anything that should be complicated but I'm not
having much success.
I'm trying to run a query to one table in a SQL database and return the
value of only a single record. I'll use those values plus other user entered
values to submit a new record to a second table in the same SQL database.
It seems like I have it somewhat sorted out, but querying the secondary data
source tries to return all records from that table to the form, but I only
want it to return the one record that matches the value of another field that
the user input. The table is far to large to return all records and then
filter them in a reasonable time. How do I get the query for the secondary
data to not return the entire table?
Seems I can do this just fine with the main connection because it has
queryFields, but the secondary doesn't have queryFields.
Thanks
having much success.
I'm trying to run a query to one table in a SQL database and return the
value of only a single record. I'll use those values plus other user entered
values to submit a new record to a second table in the same SQL database.
It seems like I have it somewhat sorted out, but querying the secondary data
source tries to return all records from that table to the form, but I only
want it to return the one record that matches the value of another field that
the user input. The table is far to large to return all records and then
filter them in a reasonable time. How do I get the query for the secondary
data to not return the entire table?
Seems I can do this just fine with the main connection because it has
queryFields, but the secondary doesn't have queryFields.
Thanks