Auto populate data in field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here's the setup. I have a main form Customers with a field Customer Name.
This form has a subform Sites with fields Site Name and Company Name. Sites
also has a subform Equipment which has the fields Site Name and Company Name.

Here's the situation. When I move to the Equipment subform, the Site Name
populates from the data entered in the higher forms, but the Company Name
doesn't (although it does populate in the Sites subform). I have tried
adding Company Name into the Child/Master fields, but then I get a popup box
asking for a parameter value.

Does anyone have any suggestions?

Thanks for the help.
 
Here's the setup. I have a main form Customers with a field Customer Name.
This form has a subform Sites with fields Site Name and Company Name. Sites
also has a subform Equipment which has the fields Site Name and Company Name.

Here's the situation. When I move to the Equipment subform, the Site Name
populates from the data entered in the higher forms, but the Company Name
doesn't (although it does populate in the Sites subform). I have tried
adding Company Name into the Child/Master fields, but then I get a popup box
asking for a parameter value.

Does anyone have any suggestions?

Thanks for the help.
Click to expand...

What is the Recordsource of the equipment subform? Does it contain a
field for the company name? And are you using that fieldname as the
Child Link Field?

One concern: why would you WANT to store the company name,
redundantly, in the Equipment table? Sounds like it's neither
necessary nor good design!

John W. Vinson[MVP]
 
Thanks for the input. Let me explain the setup and maybe you have a better
way of doing it. I have company X, this company has sites A, B, C, etc.
Each site has equipment 1,2,3,4,etc. I need to be able to search or run a
report for a specific piece of equipment, say 2 and see not only which site
has this equipment, but also the company name. I have created separate
tables for the companies, the sites, and the equipment and created the
relationships. What do you suggest for a better layout?

SVE
 
Back
Top