From: stevecaple@commoncast.net   
      
   On Thu, 4 Dec 2008 09:18:11 -0800, Dave wrote:   
      
   > New to Paradox, our company has never used the product.   
   >  I download price lists from 4 distributors in a db table   
   > format, each one has its own structure. I get a new price list from each one   
   > at random intervals. A specific part may be available from one or more   
   > distributors. How challenging of a process would it be to create a form that   
   > I can see all the distributors and search them simultaneously for a   
   > particular part number. The only common element in each of the 4 tables   
   > would be a manufacturer part number and each table may or may not have the   
   > same numbers   
      
   Assuming that the .DBs have (as they certainly should) an index on the part   
   number, it shouldn't be all that difficult to put all four tables on one   
   form.  Perhaps an SRO (single record object: a 1 x 1 MRO) showing a single   
   record from each table, along with an unbound part number entry field, and   
   a search button that will do a setRange on each table object in turn  -   
   almost instantaneous.   
      
      
   --   
    Steve   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)