problem with repeating table

[sodino]

My problem again. I have repeating table with one drop-down formant and text
field. When choose for example from drop-down formant name, in the text
field apears forname of the same person. All the field are linked to the
secondary source (SQL base). and now I paste next row in my table. And again,
choose name and suprise...., in text field appers wrong persons forname. It's
depending what I choose in first row. For example, I choose first name on the
list, in first row OK, but in the second when choose name in field apperas
person forname from the first row. When I in the first row choose the last
name on the list, in the second and other rows all works good.
I send data after filling all rows (1-4).

thanks

 

[S.Y.M. Wong-A-Ton]

The description of your problem is not entirely clear to me, but it sounds as
if you need to use a rule on the drop-down to populate the text field. And
when you are populating the field, use the current() function to filter the
data ([Filter Data...] button on "Select a Field or Group" dialog box) coming
from the secondary data source.

If you are using an ID for the values in the drop-down, this should be
relatively easy to do. The action for the rule should look something like
this:

textfield = @lastname[@id = current()]

where textfield is the text field on your form, @lastname the value for the
last name of a person being pulled from the secondary data source, @id the ID
of a person being pulled from the secondary data source, and current() the
value of the currently selected item in the drop-down (= ID of selected
person) in the repeating table. Here I've assumed that you are displaying the
first name of a person in the drop-down and that you would like to retrieve
and show the person's last name in the text field.

If you still have difficulty getting it to work, let me know. Then I'll walk
you through all the steps to get it done.