Guys,
This is where I think you may have a snigger at me. I have setup a database from a single table, and split this up into a number of one-many relationships using the Table Analyser wizard. This has given me all the functionality i need to be able to generate the outcomes I need.
However I know have the problem that the original raw data table has been updated and I need to update my database. How can i do this from the raw data? The table structure is below:
Raw Data Fields:
Billing
carrier
Service
Cost Centre
User Name
This splits into:
Billing Table(Billing ID, Billing Company)
Carrier Table(Carrier ID, Carrier Company)
Cost/User Table(User ID, User Name, Cost Centre)
Service Table(Service ID, Service)
These are the related so:
A user can have as many services as they want
A service is related one-many with carrier and billing
A user can only have one cost center.
So the question is if i have the original raw data how do i split it to update the tables. THe new data may have more or less users/cost centres, there may be new services and teh relationships between users and services could have changed.
So pretty tricky, and you may say impossible...any ideas?
Chris
This is where I think you may have a snigger at me. I have setup a database from a single table, and split this up into a number of one-many relationships using the Table Analyser wizard. This has given me all the functionality i need to be able to generate the outcomes I need.
However I know have the problem that the original raw data table has been updated and I need to update my database. How can i do this from the raw data? The table structure is below:
Raw Data Fields:
Billing
carrier
Service
Cost Centre
User Name
This splits into:
Billing Table(Billing ID, Billing Company)
Carrier Table(Carrier ID, Carrier Company)
Cost/User Table(User ID, User Name, Cost Centre)
Service Table(Service ID, Service)
These are the related so:
A user can have as many services as they want
A service is related one-many with carrier and billing
A user can only have one cost center.
So the question is if i have the original raw data how do i split it to update the tables. THe new data may have more or less users/cost centres, there may be new services and teh relationships between users and services could have changed.
So pretty tricky, and you may say impossible...any ideas?
Chris
