please advise

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top