interesting problem with repeating tables

M

Mike

hello I am having issues with repeating tables, which I use heavily in my
forms. After choosing to insert a new line into a table, a new line is
entered into every table in every view that I have in the forms. This doesnt
allow me to submit the forms unless I go through and delete all the null
lines from every view. Does anyone have a clue as to what is going on and a
solution to this problem. thanks much ~Mike
 
F

Franck Dauché

Hi Mike,

Do you have any code in your form? How did you add your repeating sections?
Are you sure they are bound to different part of your schema?

Regards,

Franck Dauché
 
J

Jamesy

FWIW - Snap!

I have a "Master" SQL table with child tables linked by ID. The child tables
relate to repeating sections - as this is apparently the only way to populate
SQL tables with repeating sections.

If I insert on repeating section 1, all the other sections insert too. This
only occurs when the form is bound to SQL. Presumably something to do with
the fact that all the child tables are nested to the master - and that the
data binding for all sections is set as the root master table (and can't be
changed to simply one of the children)

This is a real show-stopper.

KJ
 
Top