subform with childs

  • Thread starter Thread starter Francis
  • Start date Start date
F

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