jackjsmith88
New member
- Local time
- Today, 00:58
- Joined
- Sep 21, 2019
- Messages
- 2
Hi all,
wheneever ive created databses, its always from scratch, so no existing data to manipulate and i can easily organise one that has to be populated.
But.. now im creating one that rips reports out of SAP, and imports into Access, so that i can create various form based features and reports with charts etc,
i imported this years wad of data off, that lays out like so:
Call it RawData
Account Number
Account Name
ProjectID
ManualPriceAdjustment
BullingDocumentNumber
DeliveryNoteNumber
SalesDocumentNumber
CostPrice
NetPrice
Tax
MarginalPercentage
MarginNet
and a few more.. the table analyser, correctly reads what data needs to go in what table, but then it creates a shed load of corrections and wants to overwrite all my data with weird replacements
So what i want to do, is split the data myself, by creating one to many relationships in several tables, so that each table has the link button to display a subtable with corresponding info.
I started with SalesorderNumber.
So i wanted to create a table that autopopulates the field based on the data from the other table, and links them both together, and autopopulates based on whats coming from the RawData.
I suspect im going about this the wrong way, and i even played with the thought of an update query? but i don't know what im doing there?
if anyone can give me a gentle nudge in the right direction?
greatly appreaciated.
BR
Jack
wheneever ive created databses, its always from scratch, so no existing data to manipulate and i can easily organise one that has to be populated.
But.. now im creating one that rips reports out of SAP, and imports into Access, so that i can create various form based features and reports with charts etc,
i imported this years wad of data off, that lays out like so:
Call it RawData
Account Number
Account Name
ProjectID
ManualPriceAdjustment
BullingDocumentNumber
DeliveryNoteNumber
SalesDocumentNumber
CostPrice
NetPrice
Tax
MarginalPercentage
MarginNet
and a few more.. the table analyser, correctly reads what data needs to go in what table, but then it creates a shed load of corrections and wants to overwrite all my data with weird replacements
So what i want to do, is split the data myself, by creating one to many relationships in several tables, so that each table has the link button to display a subtable with corresponding info.
I started with SalesorderNumber.
So i wanted to create a table that autopopulates the field based on the data from the other table, and links them both together, and autopopulates based on whats coming from the RawData.
I suspect im going about this the wrong way, and i even played with the thought of an update query? but i don't know what im doing there?
if anyone can give me a gentle nudge in the right direction?
greatly appreaciated.
BR
Jack