Having trouble with design
I have a problem that I can’t seem to get head my around. I’m trying to build a database for processing window blinds orders. I first looked at the possibility of using a portal in this situation but as some of the blinds will require braking down in to many options, which will require itemised pricing and measurement details etc. and this just seems out the scope of a portal.
The ERD looks a bit like this,
Order Summary (Portal)
Customers -> Orders Details -> Order line items <- Blind Types <-Component List |
I hope that someone has come across this situation, before.