AnsweredAssumed Answered

Need help with relationship

Question asked by EvanScott on Jan 27, 2011
Latest reply on Jan 27, 2011 by philmodjunk


Need help with relationship


I have a DB that has a table for prices, a table for comleted products, and a table for billing, and a table for customers. I need to get the DB to fetch all of the data since the last billing cycle and generate a bill of all the completed products for the particular customer. However, I don't know what the best way to that is other than doing a huge massive scipt that will require lots of time if a price changes or another customer comes on board.