Greetings all database workers,
I am still working on the table structure of a database to help my dad and brother with plumbing estimates. There are three tables relating to the Products table to store product details, defined as ‘Descriptors’. The descriptors are: Size, Angle, Flowrate, Flue, kW, m3p/h, Watts and Manufacturer (the only non-numeric descriptor).
So I have Descriptors and Products, but as each product can have different descriptors, somehow I need to link the descriptor values together. To do this I thought about consolidating descriptors appropriate to the products, for example, for radiators, we need to know (Size, Watts), so in the corresponding DescriptorDetails could be (400x600mm, 2111w). I realise this is not recommended and will make searching by the fields Size or Watts really difficult.
Does anyone know a better and also simple way to combine/link these descriptors to the appropriate product? I think I could do it using another field, something like ‘ProdDescValue’ in the ProductDescriptors table and in the many to many table linking the descriptors together with this field – this is just an idea, not confident about it at all, so any thoughts on this, or an alternative method, or advice would be much appreciated.
Have attached a PDF Relationship Report of the table structure so far - I hope this all makes sense!
When (if!) I eventually get something up and running, will very gladly post on the forum for anyone out there with a similar project J
Thank you.
I am still working on the table structure of a database to help my dad and brother with plumbing estimates. There are three tables relating to the Products table to store product details, defined as ‘Descriptors’. The descriptors are: Size, Angle, Flowrate, Flue, kW, m3p/h, Watts and Manufacturer (the only non-numeric descriptor).
So I have Descriptors and Products, but as each product can have different descriptors, somehow I need to link the descriptor values together. To do this I thought about consolidating descriptors appropriate to the products, for example, for radiators, we need to know (Size, Watts), so in the corresponding DescriptorDetails could be (400x600mm, 2111w). I realise this is not recommended and will make searching by the fields Size or Watts really difficult.
Does anyone know a better and also simple way to combine/link these descriptors to the appropriate product? I think I could do it using another field, something like ‘ProdDescValue’ in the ProductDescriptors table and in the many to many table linking the descriptors together with this field – this is just an idea, not confident about it at all, so any thoughts on this, or an alternative method, or advice would be much appreciated.
Have attached a PDF Relationship Report of the table structure so far - I hope this all makes sense!
When (if!) I eventually get something up and running, will very gladly post on the forum for anyone out there with a similar project J
Thank you.