Oct 03 2020 04:48 PM
Beginner here not sure how to word what I'm looking for. I'm starting with a product number field that will generate another set of corresponding numbers (fields). The thing is that it may be only a 2nd set of numbers or it could be dozens of sets of numbers all corresponding to the original product number. Can I set up a form where the user can have that option to enter as many sets as necessary? Please feel free to reach out for further explanation.
Oct 04 2020 07:50 AM
This sounds like it is similar to a Bill of Materials situation.
Check out the BoM download on Ken Sheriden's Download site.
The key here is that your TABLE structure has to be set up properly to support this adequately.
Start there, then look into an interface to implement it.
Oct 07 2020 08:16 PM
This is the right idea. Although I'm having a little trouble figuring out how the data is entered for this to work. I'll play with the table structure. Thanks for the direction.
Oct 08 2020 07:53 AM
@Mannyg024 Ken is a major contributor at Microsoft Answers. I'm sure any followups posted there would get his personal attention.
Oct 10 2020 07:19 PM
I'm trying something different, but now I've run into a new set of problems. I was wondering if you could point me in the right direction.