AnsweredAssumed Answered

Having trouble with design

Question asked by JohnBrennan on Apr 5, 2014
Latest reply on Apr 9, 2014 by JohnBrennan


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                                                          |

                                                         Production lists


                                                          Invoice Ledger       


     I hope that someone has come across this situation, before.