Project with multiple Part Numbers

  • Thread starter Thread starter WireGuy
  • Start date Start date
W

WireGuy

I have a project number and under this overall number, I can have many Part
numbers. I'd like to have a field "hidden" on my form that includes all the
part number within the overall project number.

This would allow me to include the parts numbers within the email sent to
the users; when using the DoCmd.SendObject.

Any ideas?

Thanks!
Wireguy
 
What about using two tables in a one-to-many relationship for
Projects-to-Parts and then use form/subform for display/data entry?
 
I believe I have the set up as you stated. The form and sub-form are working
as designed. The problem is when I want to send the emails (using the
SendObject), I can't figure out how to grab all the parts; and since a
project can have many parts, how does it know to grab all of them? Is there
a way that I can create a hidden field and define a concatenate within that
field? I don't know of a formula to do this, but it may be handle and may be
others have developed this fix already. I'm hoping!

Thanks,
WireGuy
 
Back
Top