 | |
#11
 
| |||
| |||
|
Re: Can I do this? -
12-04-2008
, 12:08 PM
|
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 |
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
#12
| |||
| |||
|
|
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 |
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
#13
| |||
| |||
|
|
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 |
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
#14
| |||
| |||
|
|
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 |
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
#15
| |||
| |||
|
|
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 |
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
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.