| Subject: | Splitting an Import Table |
| Posted by: | noodnutt (noodnu…@gmail.com) |
| Date: | Sun, 16 Feb 2020 |
Hi Team
Apologies for the lengthy post, just felt I needed to clearly outline what it is I need to do.
Was hoping someone could assist with the best Update Query approach.
I have 44 fields of data importing, anywhere from 1 to 100 rows of data, multiple times a day.
I have tblImport fields labelled as F1 to F44 and needs to be split into 4 tables.
Essentially, my question is, where to add the Auto PK, and how to copy this to 3 additional tables.
As always, many thanks for any assistance.
Cheers
Mark.
tblJobs
anfRecordID = PK ( AutoNumber )
dtfDate = AutoDateStamp
lnfAccCode = Long ( F1 )
txfDepotCode = Text ( F22 )
txfServCode = Text ( F20 )
txfFileName = Text ( F44 )
tblJobs_From
lnfRecordID = Long ( Needs to be copied from PK )
lnfC_AddCode = Long ( F3 )
txfC_Ref = Text ( F10 )
txfC_Con = Text ( F11 )
txfC_Spec = Text ( F34 )
dtfC_Ready = ShortTime ( F32 )
dtfC_Prefer = ShortTime ( F33 )
dtfC_Date = ShortDate ( F2 )
tblJobs_To
lnfRecordID = Long ( Needs to be copied from PK )
lnfD_AddCode = Long ( F3 )
txfD_Ref = Text ( F10 )
txfD_Con = Text ( F11 )
txfD_Spec = Text ( F34 )
dtfD_Time = ShortTime ( F32 )
dtfD_Prefer = ShortTime ( F33 )
dtfD_Date = ShortDate ( F2 )
tblLoads
lnfRecordID = Long ( Needs to be copied from PK )
txfI_Type = Text ( F40 )
txfI_Desc = Text ( F24 )
txfI_Stack = Text ( F41 )
txfI_DG = Text ( F42 )
txfI_Class = Text ( F43 )
dnfI_Qty = Double ( F25 )
dnfI_Space = Double ( F26 )
dnfI_Weight = Double ( F28 )
dnfI_Cube = Double ( F27 )
dnfI_Height = Double ( F29 )
dnfI_Length = Double ( F30 )
dnfI_Width = Double ( F31 )