AnsweredAssumed Answered

Having trouble with design

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

Title

Having trouble with design

Post

     Help!

     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.

Outcomes