please advise

26 Mar 2006 10:44 PM

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

27 Mar 2006 4:39 AM

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

Show quoteHide quote

"rodchar" <rodc***@discussions.microsoft.com> schreef in bericht
news:1F989D6E-D27E-45F4-8350-F128F4DED271@microsoft.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
>