M
mohd21uk via AccessMonster.com
I have a table called tbl CATS which I have imported from a spreadsheet I
have then used table analyser to split the table inorder to normalise it.
The table was originally in the following format below:
tbl CATS
WBS Code User Id User Name Date A/A Type Hours
GB2-L0144.02 205445 John Edwards 03/01/2006 401 1
GB2-L0144.02 205445 John Edwards 03/01/2006 40. 7.5
GB2-L0155.02 315454 Michael Andrews 05/05/2006 401 6.5
GB2-L0155.02 315454 Micheal Andrews 05/05/2006 500 3.2
GB2-L0166.03 653324 Claire Edwards 06/06/2006 690 7.5
GB2-L0166.03 653324 Claire Edwards 06/06/2006 320 2.5
GB2-L0166.03 653324 Claire Edwards 06/06/2006 401 8.5
I have normalised this table in the following tables by splitting fields
containing repeated fields into seperate tables:
tbl WBS Code
WBS Code
tbl User
User Id
User Name
tbl A/A Type
A/A TyPE
Table 1 (a duplicate of table CATS) contains a lookup to the above fields and
includes date and hours which have not been exported to another table. Since
I have used the table analyser all of this has been created through the
automated process with relationships being created as well.
I would like to import and tbl CATS on a regular basis and use it to update
the existing table. I am just wondering how this can be doen when the tables
rae related ??????????
have then used table analyser to split the table inorder to normalise it.
The table was originally in the following format below:
tbl CATS
WBS Code User Id User Name Date A/A Type Hours
GB2-L0144.02 205445 John Edwards 03/01/2006 401 1
GB2-L0144.02 205445 John Edwards 03/01/2006 40. 7.5
GB2-L0155.02 315454 Michael Andrews 05/05/2006 401 6.5
GB2-L0155.02 315454 Micheal Andrews 05/05/2006 500 3.2
GB2-L0166.03 653324 Claire Edwards 06/06/2006 690 7.5
GB2-L0166.03 653324 Claire Edwards 06/06/2006 320 2.5
GB2-L0166.03 653324 Claire Edwards 06/06/2006 401 8.5
I have normalised this table in the following tables by splitting fields
containing repeated fields into seperate tables:
tbl WBS Code
WBS Code
tbl User
User Id
User Name
tbl A/A Type
A/A TyPE
Table 1 (a duplicate of table CATS) contains a lookup to the above fields and
includes date and hours which have not been exported to another table. Since
I have used the table analyser all of this has been created through the
automated process with relationships being created as well.
I would like to import and tbl CATS on a regular basis and use it to update
the existing table. I am just wondering how this can be doen when the tables
rae related ??????????