R
ridawg
Hey,
I'm trying to create an InfoPath form that works with an Access Database.
This is the Plan:
Default View (Search) - This view includes several fields to search against
the database and returns about 5 fields plus a button called Details that
will take you to a view called Details that displays all the fields for the
selected record for updating.
Details View - all the fields are displayed for editing.
New Record View - Same as the details view but all the fields would be blank.
I've created the Search view and it's working great. The problem I'm having
is when I click the Details button instead of seeing just the record I
selected I'm seeing all the records in the database. I've created a tempID
field and set the value of it to the Rec_ID by creating a rule for the
Details button. But I can't seem to figure out how to match up the tempID and
Rec_ID to only display the selected record in my Details view.
I haven't had much luck finding an example of how to do this so any help
would be much appreciated!
I'm trying to create an InfoPath form that works with an Access Database.
This is the Plan:
Default View (Search) - This view includes several fields to search against
the database and returns about 5 fields plus a button called Details that
will take you to a view called Details that displays all the fields for the
selected record for updating.
Details View - all the fields are displayed for editing.
New Record View - Same as the details view but all the fields would be blank.
I've created the Search view and it's working great. The problem I'm having
is when I click the Details button instead of seeing just the record I
selected I'm seeing all the records in the database. I've created a tempID
field and set the value of it to the Rec_ID by creating a rule for the
Details button. But I can't seem to figure out how to match up the tempID and
Rec_ID to only display the selected record in my Details view.
I haven't had much luck finding an example of how to do this so any help
would be much appreciated!