dynamictiger
Technical User
I have a table set up for stock. This is product I buy in on a jobbing basis.
I have a table set up for suppliers.
Some suppliers can supply more than one group of product. For example some can supply pipe and valves, others can supply pipe only.
However, the prices are volatile due to changing import rates, size of job and so on.
I am trying to think of a way to create a table that shows stockID for a part we will say 300 mm Pipe. Then shows the suppliers we will call them MyPipe and HisPipe. Then has the pricing for both suppliers.
Normalisation is starting to work against this model, and I can not see how to normalise it.
I have a table set up for suppliers.
Some suppliers can supply more than one group of product. For example some can supply pipe and valves, others can supply pipe only.
However, the prices are volatile due to changing import rates, size of job and so on.
I am trying to think of a way to create a table that shows stockID for a part we will say 300 mm Pipe. Then shows the suppliers we will call them MyPipe and HisPipe. Then has the pricing for both suppliers.
Normalisation is starting to work against this model, and I can not see how to normalise it.
