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]]

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" <ro*****@discussions.microsoft.com> schreef in bericht
news:1F**********************************@microsof t.com...

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