Fritz, Thanks for the input. I already have a table that compiles all this information. I am experimenting with using views on this particular project vs temp tables. I am trying to stay away from the update command and use just a refresh command in the form. If this is the speediest and most efficient manner.
I will read the suggested article, RAZZAK. James Belisle Making Information Systems People Friendly Since 1990 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dr. Fritz Luettgens Sent: Monday, March 03, 2014 7:14 AM To: RBASE-L Mailing List Subject: [RBASE-L] - AW: [RBASE-L] - most efficient use of view Hi Jim, might be too simple, but ... reliable ... a) to work with your 3 tables, you have to set up a form on these 3 and ... b) to combine results: create one or more temp.tables based on your 3 tables that includes the results of your 5 planned views (refresh) c) base advanced analytics (forms/reports/views a.s.o) on b) and ... you can set up all this, b) and c) into a) ... a nice little form that does all the job with custom eep´s. Advantage: you have all in one Fritz -----Ursprüngliche Nachricht----- Von: [email protected] [mailto:[email protected]] Im Auftrag von Jim Belisle Gesendet: Montag, 3. März 2014 13:38 An: RBASE-L Mailing List Betreff: [RBASE-L] - most efficient use of view Ultimate goal: Combine up to five views into one so I have real time part inventory. What I need: Speediest way to accomplish this task. I think I will need to use OUTER JOINS and I have never done that before. View 1: Two col. View (partnum, piece total) for open order parts. View 2: Two col. View (partnum, piece total) for alocated parts. View 3: Two col. View (partnum, piece total) for Inventory parts. View 4: Two col. View (partnum, piece total) for further process parts. View 5: Two col. View (partnum, piece total) for out source parts. The first two views are based off of two different tables. The last three views are based off the same table. Each row in that table has the partnum designated to a particular type of inventory. I want to combine all five views into one view and base a form off the view. I know I can use a table but the update process using a table is I think more code intensive. Basing the form on a permanent view with a refresh every 30 seconds or so will accomplish what I want. I did try a LEFT OUTER JOIN on two of the views as a test but it seemed very SLOW so I am not convinced I did it correctly. Any suggestions as to the best way to accomplish this? James Belisle Making Information Systems People Friendly Since 1990
