Repeating table with dropdown from secondary source

[cjfer]

Apologies if I'm making a repeat post on this matter. I have checked this
forum and found it quite informative, so I hope you guys can help me out.
I'm fairly new at IP and hope to get a solution based NOT on coding. Note,
I'm using IP 2003

I am using an Access database with a main source and a secondary source.
Main:
Tests
:TestID (autonumber)
:TestTrainingCode
:TestEmployeeID
:TestScore
:TestDate


Secondary source
Employees
:EmployeeID
:Name
----> bunch of other information


Trainings
:TrainingID
:TrainingCode


My objective is to have a very simple tool for when you need to fill out the
scores of all the tests of a particular training. What I wanted it was for
the user to be able to see a repeating table with a drop down of all the
Names and then automatically fill in the appropiate EmployeeID (which is why
I have the secondary source)

I thought that implied having a temporary field (tempfield) that will allow
a pull down of the different participants and have it retrieve the EmployeeID
from the Secondary Source and save it as TestEmployeeID. It will looks
somewhat like this:

Test Form (the important part anyways)
| Employee Name | Employee Id | Grade <----- header
| tempfield | TestEmployeeID | TestGrade <-----
repeating line on table


for clarification:
--- tempfield = dropdown list of Name using secondary source Employees
--- TestEmployeeID = field automatically filled by tempfield such that it is
EmployeeID [which Name = tempfield]


My main problem is that everytime I try adding this tempfield to the Main
repeating table, IP gives me an error stating that such a field doesn't
belong there and I should move it, making it overwrite all the EmployeeIDs on
the table.

I have tried changing the characteristics of the tempfield so it will be
accepted in the main repeating table without success. I even tried making it
work with a blue i message, and still no luck. That includes trying
unsuccesfully using several permutations of the current() function.

The closest solution I have come up with has a major problem. I can get the
drop down to work appropiatly (even with the error message) but everytime I
change the Employee name the TestEmployeeID fields change accordingly. I have
tried using current() but then nothing changes.

 

[Carlos F.]

Please tell me if what I am asking is beyond the scope of Infopath, so
I'll start pursuing other avenues instead of trying to get this thing
to work.

 

[Carlos F.]

Nevermind! It was staring me in the face but I just couldn't see it.

I would like to thank

http://enterprise-solutions.swits.n...election-secondary-data-source&c=infopath2003

for the example. It made it abundatly clear to me what was it that I
wanted to do. Instead of leaving Infopath use the default values for
Value/Display, by changing them it allowed me to use the repeating
table as I needed without the use of a temporary field or table.

Thanks again,