wattmhite Posted August 15, 2019 Posted August 15, 2019 (edited) Good Morning! What is the best way to achieve this type of layout where I can have 4-5 tables shown and sorted with hundreds of accounts on one layout/page? Would you suggest 4-5 portals with filtered settings or is there a better way? Edited August 15, 2019 by wattmhite
Steve Martino Posted August 15, 2019 Posted August 15, 2019 Are the tables are related? Say starting from the left column, the 2nd column shows records related to the first column, the 3rd column show records related to the second. Or Are they just records from 5 different unrelated tables, shown as a dashboard?
wattmhite Posted August 15, 2019 Author Posted August 15, 2019 Hi Steve. All the data is from one table but would like to show the data differently on each column. So for column 1, the field (Status) for each record would sort or filter to only show (Unquoted) Records, Column 2 would show only (Quoted) records from the same table. My database has over 40,000 records so I am very cautious about too many calculations and making the layout as optimized as possible
mr_vodka Posted August 27, 2019 Posted August 27, 2019 40,000 records shouldnt be too bad. You could of course run a server routine that can gather the list into fields and display those utility fields.
Recommended Posts
This topic is 1915 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now