View Single Post
  #1 (permalink)  
Old April 14th, 2008, 09:03 PM
sunny76 sunny76 is offline
Authorized User
Points: 172, Level: 3
Points: 172, Level: 3 Points: 172, Level: 3 Points: 172, Level: 3
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2005
Location: Singapore, , Singapore.
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts
Default Need to match data in all fields in 2 tables

Hi,

I need to match the data in all the fields between 2 tables.

eg.
Field 1 (Table 1) = Field 2 (Table 2)
Field 2 (Table 1) = Field 2 (Table 2)
so on......

Using the wizard, I'm only able to match 1 field at a time and this is very time consuming as I have 45 fields to match. Any advise?