Hi, mikeuhd!
MS Access is, as you probably know, relational database program.
Word "relational" means that you could certainly relate your 2 tables
by making a third.
Table3 RELATION
T3ID AutoNumber
Table1 PartNumberID
Table2 PartNumberID.
Table 3 should look like:
T3ID Table1ID Table2ID
1 1 1
2 1 2
3 1 3
.
.
.
454 1 454
etc.
You could make a form based on those 3 tables.
Could you send to group your Access database, maybe I could make that
fom for you.
Sincerelly yours,
Ivan B. Delic
--- In [email protected], "mikeuhd" <[EMAIL PROTECTED]> wrote:
>
> I have 2 tables with part number and description fields with more
> than 45000 rows each. i need to select the describtion from table 1
> that matches desc. from table 2 based on a high percentage word
match
> or some algorithm. for example, partnumber 1 from tbl 1 should
match
> to part number 454 from table 2. somebody mentioned fuzzy logic,
but
> too complicated for me. i'm just new to acccess. thanks in advance
>
> table 1
> PartNumber DESCRIPTION
> -------------------------------------------
> 1 |Receptacle Circuit Tester - Blue
> 2 |Drill Down PC Monitor Pattern Generator
> 3 |Test Product Description:Holster T5 Complian
> 4 |25 feet tape measuer -chrome
>
> TABLE 2
> PartNumber DESCRIPTION
> -----------------------------------------------------
> 100 |Scope Bandwidth:30 MHz Dual-Trace
> 252 |H5 Holster T5
> 365 |Chrome 25' tape walmart
> 454 |Blue - circut tester by general tools
> 556 |
>
