D
David F-B
For the last few weeks I have been trying to move out Company address
data from a monolithic single table database.
I want to have a list of unique companies and to link that back to the
records in the main table so that instead of cutting and pasting the
whole address data whenever a member moves, I can be in a position to
only need to change the Company ID number in the Membership/Customer
record.
I have had major surgery with less stress than trying to acomplish
what seems such a simple and obvious thing to do!
Right, enough grouching!
So far I have created a new table called Companies. I have appended
the data I wanted into it. The data is a list of company names from
the Main Table. Each company has a unqie ID number, courtesy of an
autonumber field, CompanyID No.
I have also created a field on the main table called CompanyID No.
I can do a query which lists
Company.CompanyID No
Company. CompanyName
MainTable.CompanyID No
MainTable.CompanyName
The Company ID lists 1 to 1500 ok, followed by the corresponding
Company Name company name. Then the same details from the Main Table.
I have tried umpteen times to copy the Company.CompanyID No into the
currently blank MainTable CompanyID No. Absolutely nothing happens.
It is so frustrating. I can see the columns all ligning up. If I
could just cut and past then the job would be done.
Why can't I copy the data fom the same field in one table to the same
field in another table. If this is at all possible, please can
someone explain where I'm going wrong, before I go loopy.
Many thanks for all help given.
David
data from a monolithic single table database.
I want to have a list of unique companies and to link that back to the
records in the main table so that instead of cutting and pasting the
whole address data whenever a member moves, I can be in a position to
only need to change the Company ID number in the Membership/Customer
record.
I have had major surgery with less stress than trying to acomplish
what seems such a simple and obvious thing to do!
Right, enough grouching!
So far I have created a new table called Companies. I have appended
the data I wanted into it. The data is a list of company names from
the Main Table. Each company has a unqie ID number, courtesy of an
autonumber field, CompanyID No.
I have also created a field on the main table called CompanyID No.
I can do a query which lists
Company.CompanyID No
Company. CompanyName
MainTable.CompanyID No
MainTable.CompanyName
The Company ID lists 1 to 1500 ok, followed by the corresponding
Company Name company name. Then the same details from the Main Table.
I have tried umpteen times to copy the Company.CompanyID No into the
currently blank MainTable CompanyID No. Absolutely nothing happens.
It is so frustrating. I can see the columns all ligning up. If I
could just cut and past then the job would be done.
Why can't I copy the data fom the same field in one table to the same
field in another table. If this is at all possible, please can
someone explain where I'm going wrong, before I go loopy.
Many thanks for all help given.
David