I'm currently designing a database for an inspection body that performs controls and inspections of wiring systems. The price for the inspection depends on the power of the wiring.
I'm experiencing some problem in the design of the price list for the DB. The actual price list has power brackets and a price value for each of these brackets. If I write the price list table and the wiring table as:
PriceList([U]Bracket[/U], PowerMin, PowerMax, Price) Wiring ([U]WiringID[/U], Power)
I'm unable to define a referential integrity between the two tables in order to define the price for the inspection.
How can I solve the problem?
Thank you in advance and sorry for the bad English!