Anthony.DG
Registered User.
- Local time
- Yesterday, 17:45
- Joined
- Oct 18, 2019
- Messages
- 27
I have a database that has these different tables that stores records pertaining to Material.
So I figure this might be the way to go instead of having multi tables that have the very similar data. It could form other problems Im not aware of. I know I'll have to adjust all relevant queries, vba and other whatnots, I dont mind that. What do you guys think?
- tblTicketing - Materials put on a truck weighed
- tblInvoiceMatDetail - Materials selected for estimates
- tblDemoDeposit
a. Bank of construction site demo material in our yard that we will later recycle
b. Bank of material that’s purchase from other quarries and deposited in our yard.
- ToInvoicing - for estimates and billing
- ToTicket – for weight tickets
- ToBank – for stored material on site
So I figure this might be the way to go instead of having multi tables that have the very similar data. It could form other problems Im not aware of. I know I'll have to adjust all relevant queries, vba and other whatnots, I dont mind that. What do you guys think?