Re Form or Query Issue

[phillbaker]

I have this subform which records all the training undertaken by a client. It also stores the ID of the client which it grabs from the main form and this is all stored in a training table. One thing it use to do was also record the clients surname in the table which it also use to get from the main form but for some reason has stopped doing this.

The subform is using a query and is getting the following information

What could be wrong with this

phil

 

[boblarson]

What could be wrong with this

Well, one wrong thing is storing the Surname in addition to the ID. The ID should be the only identifier stored for the client in the child table.

 

[phillbaker]

sorry it is only stored as an identifier in the child table its not being used as anything else. Just for the person using it could cross refernence with other information.

 

[boblarson]

How is the information supposedly getting from the main form to the subform?