AnsweredAssumed Answered

Linking Tables

Question asked by gsbilsky on Feb 16, 2010
Latest reply on Feb 16, 2010 by philmodjunk

Title

Linking Tables

Post

This is my last attempt.

 

I challenge any of you to the following:

 

Build two table with two fields each.  This should take 3 minutes.

 

Table One: FieldOne FieledTwo

 

Table Two:  FieldOne  FieldTwo

 

Table One has the following data:

 

FieldOne                                                           FieldTwo is empty

 

CHECKCARD 0124 APL*ITUNES 23458 2223       

CHECKCARD 0222 APL*ITUNES 33233 3322       

COOK OUT FREEDOM DRPS                                

CHECKCARD 0111 PAT OBRIANS BAR NOLA

 

 

Table Two has the following data:

 

FieldOne                                                        FieldTwo

APL*ITUNES                                                   Apple Itunes

COOK OUT                                                     Cook Out

PAT OBRIANS                                                 Pat O'Brians

 

Ok, now link TableOne FieldOne with TableTwo FieldOne and replace all of TableOne FieldTwo with data from TableTwo FieldTwo.

 

Simple with SQL in Access.  Can anyone write a script to do this?

 

I want to thank all who have helped me get close, but not over the edge.

 

If this can not be done I will be staying with Access.

Outcomes