Newbie Questions

Re: How to return secondary data when using query or pull-down lists

Hilary Stoupa — Tue, 15 Dec 2009 15:41:42 GMT

I'm sorry to be slow -- can you tell me what you mean by 'attempt to join the deduction description'? Are you talking about adding it to the repeating table that shows the deduction codes? Or are you talking about your data source?

Re: How to return secondary data when using query or pull-down lists

GregAppelt — Tue, 15 Dec 2009 01:49:25 GMT

Yes, and Yes. When I structure the form correctly, I can get the repeating table to show each of the deduction codes the employee has a record for. However, when I attempt to join the deduction description, it acts like there is no join.

Re: How to return secondary data when using query or pull-down lists

Hilary Stoupa — Thu, 10 Dec 2009 02:01:02 GMT

Hi:

So, are you getting data back from your child table? Is the repeating table inside the repeating section that is bound to the EMPL group?

How to return secondary data when using query or pull-down lists

GregAppelt — Wed, 09 Dec 2009 03:04:34 GMT

I'm new to Infopath but I believe I have a common project that I just can't figure out. I can't get the a secondary table's retrieve data to populate in a repeating table column next to the primary table data.

EMPL table
empl_id int (PK)
first_name nvarchar(20)

DED(uctions) table
ded_cd int (PK)
ded_desc nvarchar(30)

EMPL_DED
empl_id int
ded_cd int
CONSTRAINT MPK (empl_id, ded_cd)

Infopath Form:
Query 'section' [empl_id]

Data 'repeating section' [empl_id],[first_name]
'repeating table' [ded_cd],[ded_desc]

Before I make this post any longer - can anyone direct me to an existing post about this or should I continue my question with my data sources outlined?