please advise

[rodchar]

hey all,

i need to somehow link 2 tables that do not have a definite key and was
hoping i could get some advice on this.

For example:
Table1.Field1 = 3830 Washington Rd
Table2.Field1 = 3830 Washington Rd, STE 11

I need to somehow link each record Table1 with possible comparisons in
Table2. What would be the most efficient way of doing this in a VB program?

thanks,
rodchar

[Cor Ligthert [MVP]]

Re: please advise

Rodchar,

Probably is the most efficience to use an extra column in table 2. I assume
that you have to fill that with a loop. The expression is probably to simple
for this.

Cor

"rodchar" <rodchar@discus sions.microsoft .com> schreef in bericht
news:1F989D6E-D27E-45F4-8350-F128F4DED271@mi crosoft.com...[color=blue]
> hey all,
>
> i need to somehow link 2 tables that do not have a definite key and was
> hoping i could get some advice on this.
>
> For example:
> Table1.Field1 = 3830 Washington Rd
> Table2.Field1 = 3830 Washington Rd, STE 11
>
> I need to somehow link each record Table1 with possible comparisons in
> Table2. What would be the most efficient way of doing this in a VB
> program?
>
> thanks,
> rodchar
>[/color]