Can I do this?

#1

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

#2

Please don't cross post. Most of us read all the groups so this doesn't
get you faster or better help. Check out the cnews (corel) groups.

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
Offices in the United States and Germany
Providing solutions to health care, business, governments and
non-profits since 1982

Dave wrote:

Quote:

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

#3

Please don't cross post. Most of us read all the groups so this doesn't
get you faster or better help. Check out the cnews (corel) groups.

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
Offices in the United States and Germany
Providing solutions to health care, business, governments and
non-profits since 1982

Dave wrote:

Quote:

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

#4

Please don't cross post. Most of us read all the groups so this doesn't
get you faster or better help. Check out the cnews (corel) groups.

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
Offices in the United States and Germany
Providing solutions to health care, business, governments and
non-profits since 1982

Dave wrote:

Quote:

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

#5

Please don't cross post. Most of us read all the groups so this doesn't
get you faster or better help. Check out the cnews (corel) groups.

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
Offices in the United States and Germany
Providing solutions to health care, business, governments and
non-profits since 1982

Dave wrote:

Quote:

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

#6

Please don't cross post. Most of us read all the groups so this doesn't
get you faster or better help. Check out the cnews (corel) groups.

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
Offices in the United States and Germany
Providing solutions to health care, business, governments and
non-profits since 1982

Dave wrote:

Quote:

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

#7

Please don't cross post. Most of us read all the groups so this doesn't
get you faster or better help. Check out the cnews (corel) groups.

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
Offices in the United States and Germany
Providing solutions to health care, business, governments and
non-profits since 1982

Dave wrote:

Quote:

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

#8

Please don't cross post. Most of us read all the groups so this doesn't
get you faster or better help. Check out the cnews (corel) groups.

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
Offices in the United States and Germany
Providing solutions to health care, business, governments and
non-profits since 1982

Dave wrote:

Quote:

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

#9

On Thu, 4 Dec 2008 09:18:11 -0800, Dave wrote:

Quote:

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

#10

On Thu, 4 Dec 2008 09:18:11 -0800, Dave wrote:

Quote:

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