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
