C
CJ
Can we use master data tables to populate list boxes and convert those
back-and-forth from/to id numbers?
Here is a more detailed scenario:
You should be able to do this but I can't figure out how because I'm
new to InfoPath.
Let's pretend we have a connected Access 2003 database with two
tables (to keep things simple for this example), we want to make an
InfoPath form that allows us to query/update/ and add new records to
the database.
In the database, let's call the first table 'animals' with the
following fields:
animal_id , class_id, animal_name. Let's call the second table 'class'
and have these fields: class _id (1,2,3) and class_type (dog, cat,
burro). The two tables are joined by 'class_id'. Many individual
animals can share the same class_type.
Now in InfoPath, we want a drop down that provides all the class types
(dog, cat, burro) by reading from 'class.class_type' and presenting
this text in the drop down, BUT when updating or creating a new record
the correct class_id (1,2,3) for that class writes to animals.class_id
.. Secondly, we need to be able to use a drop down in the query section
of our form that will read animals.class_Id (1,2,3) but display it in
the drop down as (dog, cat, burro).
back-and-forth from/to id numbers?
Here is a more detailed scenario:
You should be able to do this but I can't figure out how because I'm
new to InfoPath.
Let's pretend we have a connected Access 2003 database with two
tables (to keep things simple for this example), we want to make an
InfoPath form that allows us to query/update/ and add new records to
the database.
In the database, let's call the first table 'animals' with the
following fields:
animal_id , class_id, animal_name. Let's call the second table 'class'
and have these fields: class _id (1,2,3) and class_type (dog, cat,
burro). The two tables are joined by 'class_id'. Many individual
animals can share the same class_type.
Now in InfoPath, we want a drop down that provides all the class types
(dog, cat, burro) by reading from 'class.class_type' and presenting
this text in the drop down, BUT when updating or creating a new record
the correct class_id (1,2,3) for that class writes to animals.class_id
.. Secondly, we need to be able to use a drop down in the query section
of our form that will read animals.class_Id (1,2,3) but display it in
the drop down as (dog, cat, burro).