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.
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.