Help with relational table

Discussion created by kaiviti on Aug 16, 2016
Latest reply on Aug 16, 2016 by fmpdude

I am building a solution for  my business that supplies 4 products.  I need to have a layout that shows a portal with all the customers listed down the left and then 4 boxes across the row (one for each product) that a value is put in to show how much of each product the customer is ordering.  The qty fields need to be live so that values can be updated on the run.  They also need to create an invoice ( and update that invoice at each value change) for each company.  I should also be able to enter a date in the search field to bring up past orders for that date and for all the listed customers.

Can someone help me out with some ideas on how to do this?