By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,219 Members | 2,147 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,219 IT Pros & Developers. It's quick & easy.

please advise

P: n/a
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

Mar 26 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Mar 27 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.