Hello,

My name is Erik and i'm a Senior Database Architect with more than 15 years of experience and I also have 10 years of experience managing programmers.

The best way to ensure data relations between your objects (Product selected, type of coating, etc) is the following: you should explain to the developer that you want a 100% dynamic parent/child associations between objects without any limits on associations between objects.

If you need more details and/or want to schedule a call, we can go over your business requirements and I can help you build the technical specs for your programmer. I am also available to develop the data structure that you need.

Regards,

Erik Hanley