InfoPath Dev

 I've done alot of searching, but I can't seem to find an explanation to a simple issue.  Here's my scenario:SQL 2008 Database with the following tables: Table 'EMPL':    Column 1 'EMPL_ID' int PK, Column2 'EMPL_NAME' varchar(20) Table 'EMPL_DED':    Column 1 ...

 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.

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 ...