Phil Gilmore 28.Jan.10 10:43 AM a Web browser Approach 9.8 All Platforms
I have a database where all orders are kept. I also have another database for fleet vehicles which we use to deliver the orders. They are joined via a unique vehicle ID so that when an order is depatched a vehicle is assigned to that order. Ther are two other databases for customers and consignees which are also joined to the order database. So it's a classic example of a one to many realation.
What I would like to do is to view what orders all the vehicles are delivering in a particular week. So the view I'm after would show all vehicle registration numbers in the first column, the next six columns would be days Mon to Sat, and each cell would show all orders and detail of each order.
I know what I'm describing screams 'spreadsheet' but I'd like to know if Approach can go someway towards what I want to do.