X
xpnovice
Hi,
I have a table that contains customer details, including a unique CustId
field. There is also another table with only two fields, CustId and
CustRef. The CustRef is also a unique field required by a different
department.
I want to combine this data all into the main customer table and ditch the
two field table.
I have added a new field to the main table to accommodate the CustRef data
but would like to merge this data automatically to save entering a few
thousand records manually.
Any ideas please.
Example:
Main Table:
CustId CustRef Forename Surname
01397 Martin Jones
CustRef currently empty as I have not transferred the data.
Additional Table:
CustId CustRef
01397 AR9723
How do I get the main table reading:
CustId CustRef Forename Surname
01397 AR9723 Martin Jones
Thanks
John
I have a table that contains customer details, including a unique CustId
field. There is also another table with only two fields, CustId and
CustRef. The CustRef is also a unique field required by a different
department.
I want to combine this data all into the main customer table and ditch the
two field table.
I have added a new field to the main table to accommodate the CustRef data
but would like to merge this data automatically to save entering a few
thousand records manually.
Any ideas please.
Example:
Main Table:
CustId CustRef Forename Surname
01397 Martin Jones
CustRef currently empty as I have not transferred the data.
Additional Table:
CustId CustRef
01397 AR9723
How do I get the main table reading:
CustId CustRef Forename Surname
01397 AR9723 Martin Jones
Thanks
John