Data Mapping Question

S

speckryche

New to Infopath so forgive me if this is basic.
I have a simple Access DB that has 5 rows of related data to each primary
key - for this example I will use each row as A,B,C,D, & E.
What I am wanting to do in a form in Infopath is create a table (or
something else) that has 5 fields. The first is a drop down list of all
options to pick from in row A (this I know how to do so the drop down lists
all the items in Row A of my data source).
Then I want the next 4 text boxes (or some other kind of field in InfoPath)
to auto populate with the related data that corrosponds to the selection from
row A.
Does this make sense?
Thanks in advance for any help!
 
S

speckryche

Fantastic help! Spent many hours searching for this answer and decided to
post it on this forum - thanks a bunch Jerry!

A followup additional question that I am now trying to figure out -
hopefully I can explain clearly...

I have a repeating table with 5 rows (for this example I will call the rows
A,B,C,D & E)
Row A = Quantity (user enters manually)
Row B = Code (user picks from a drop down that is pulled from the 2nd data
source)
Row C = Description (filled in automatically from the 2nd data source based
on Row B)
Row D = Cost (filled in automatically from the data based on Row B, then
multiplied by Row A to give a total cost)
Row E = Bucket (filled in automatically from the 2nd data source based on
Row B).

The repeating table may have 2 entries, or 50 and will vary always.
Now what I am trying to do are these 2 things:

1 - after the last repeating table is entered, I need to have fields that
take the grand totals (row D) for EACH Bucket (Row E).
Example - Row E is the Bucket (or category) I have the Codes (Row B)
allocated to. I have a total of 8 different Buckets that could happen based
on the Codes (Row B) that the user enters.
Lets say there are 10 entries the user makes, which have 4 different Bucket
categories - I need to have 4 fields at the end of the table (or could be in
a different table) that pulls the combined cost totals for each of the Bucket
categories.

So hopefully that makes sense and is something that can be done.
Thank you again Jerry!
 
Top