D
Darren G
I feel this should be easy ... but it has had me stumped for days!
I'm looking to bring in data from secondary data source into a
repeating table to add extra info.
A simplified example:
Primary datasource: ref number + other data fields
Secondary datasource: ref number + name
I'm looking to produce a form hanging off SQL server to update data
that has field layout
ref number name other data fields
I've tried to do this by having a form linked to the primary datasource
and adding an expression box containing a formula that pulls the name
field from the secondary data source and filtering (effectively joining
the tables) such that primary.area = secondary.area.
This partly works, in that it picks up the correct name for the first
ref number, but then uses the same name for the subsequent ref numbers.
Hope that makes sense. Anyone got any better ideas or can see where
I'm going wrong?
(BTW didn't join the tables in the primary data source as InfoPath
wouldn't then update due to a possible many-to-one relationship.)
TIA
I'm looking to bring in data from secondary data source into a
repeating table to add extra info.
A simplified example:
Primary datasource: ref number + other data fields
Secondary datasource: ref number + name
I'm looking to produce a form hanging off SQL server to update data
that has field layout
ref number name other data fields
I've tried to do this by having a form linked to the primary datasource
and adding an expression box containing a formula that pulls the name
field from the secondary data source and filtering (effectively joining
the tables) such that primary.area = secondary.area.
This partly works, in that it picks up the correct name for the first
ref number, but then uses the same name for the subsequent ref numbers.
Hope that makes sense. Anyone got any better ideas or can see where
I'm going wrong?
(BTW didn't join the tables in the primary data source as InfoPath
wouldn't then update due to a possible many-to-one relationship.)
TIA