I'm creating a product ordering system.
Every Order database that is generated includes the date and the vendor name, and then a "Summary" Record is also created with the Date of the Order, the Vendor name, and a GetSummary Field with the total amount of the order:
In the table for my vendors I want to have a portal showing just these summary fields and the date and totals of each order.
When i create the Portal, and sort the records everything shows up nicely:
However I only want the Summary records to show, so when I filter the portal to only show the records with Type = "Filter" the Order Summary Field is blank:
I want to be able to see a list of the dates of each order and the total amount.
Can someone please assist me as to the best way to accomplish this?
Here is a link to the sample Database:
Any help with this would be much appreciated!