subform with childs

[Francis]

Link Childs:
IDangariador;IDclienteangariacao;IDreferenciaangariacao;IDvendedor;IDclientevenda;IDreferenciavenda

Link Master:
IDagente;IDagente;IDagente;IDagente;IDagente;IDagente

when i insert a new record, these fields autopopulate with the value of
IDagente, any help is aprreciated.

Thanks in advance

 

[Douglas J Steele]

You've said that the 6 controls listed under Link Childs are all linked to
the same control (IDagente) on the parent form. You need to fix the linkage
between the two if it's not correct.

 

[Francis]

yes i found a problem and i will try to implement the solution. The
problem is IDagent belongs to 6 different copies of the same table, so
it should come up with somehing like this:

Link Master:
Agent_Table.IDagente;Agent_Table_1.IDagente;Agent_Table_2.IDagente;Agent_Table_3.IDagente;Agent_Table_4.IDagente;Agent_Table_5.IDagente


But this makes another problem. What to put in Master Form's Record
Source.

 

[Douglas J. Steele]

If you've got 6 different IDagente fields in the RecordSource of your form,
you have to use aliases in the query so that each field has a unique name.
You cannot use Agent_Table.IDagente; Agent_Table_1.IDagente etc.

 

[Francis]

It's sorted thanks.

Francis