Autopopulate Client ID and Name in Subform

[kholm]

It shows on the form, but not on the table. The main form has an autonumber for Client ID and then there is the Company Name. On the next subform, I would like these two items to auto populate into the form, and they do, but when I go to the table, they are not there? Help.

 

[Rob.Mills]

Have you linked the master and child fields correctly?

 

[kholm]

Master Child

Yes, I have linked Client ID to Client ID and CompanyName to CompanyName (same in both).

 

[Rob.Mills]

Hmm. Well I've never tried linking two fields on a subform with two fields on the main form. That might be causing a problem. To be honest, the table that holds the data for the subform shouldn't have a field for the company name. Just one for the ID to link. Otherwise you're creating redundant data. And if you need to see the name of the company from the subtable there's lots of different techniques you can use like joining tables, comboboxes, dlookups, etc.

 

[kholm]

I wanna cry

Okay, I took the master/child link off of the CompanyName and used the Client ID only. When I go to add a new Job, the Client ID goes to 0 and does not add anything to the table. The link is still established for the Client ID.