a table to be split into 2 with a (1) to (M)

stargate

Registered User.
Local time
Today, 23:19
Joined
Feb 19, 2004
Messages
20
When I initially created the DB i didnt formalise it correctly. Now I understand the importance to do so. I know it needs to be normalise further but at this stage want to get the data matching correctly before normalising further.

tblclient holds information on the client and jobs forwarded to a provider and I linked this to tblpayments.

I need to extract the information from table clients into tbl jobs
e.g

JobID
Provider
DateSentToProvider
DOA
ArrivalTime
FlightNo
TimeDepart
ConnectFlightNo
Destination

This how i should have normalised it.
tblClients
tblPayments
tblJobs (1) to (m) tblclients, (m) tblpayments

I a little unsure how to move the job information data from tblclients into tbljobs and then related to payment data to tbljobs. I would appreciate if some could help move the data and linked it the payments table. Once I know how to do this I want have to ask again.

I have attached the table with some data.

I hope I havent confused you.
 

Attachments

Suggest you create you new tables normally. Use an Append Query then to add the required records from your un-normalised table. At this stage you will actually have the data in two tables. Do not worry about this at the moment.

When you have move all the data you need to move then link the tables using the Relationships diagram (See main toolbar for Relationship icon)

When you are satisfied that all is okay then delete the columns containing the duplicated data but only when you are sure all is okay

len B
 
Thanks for that. I'll give that a try.
 

Users who are viewing this thread

Back
Top Bottom