Hello,
bearing in mind I'm new to DBs and PHPRunner, here is my issue :
I have a table of products. Products number grows for each "store".
Each product contains multiple parts (from 1 to 50 let say).
Parts can be bespoke for a certain product or can be found in many products.
From what I gather, this is called a "many to many" relatioonship.
So my problems are :
- Products and Parts cannot have a strict master detail relationship otherwises individual parts become
exclusively attached to each product but I need to reuse some parts for other products...
- how to make an easy data entry for this type of things. If I have a new part that goes in 100 of my products for example.
Thanks in advance,
F.