EH_SG's latest activity
-
EEH_SG replied to the thread Solved A normalisation question.Totally. I guess I've just been putting off what I knew needed to be changed really, due to the time of the work involved I felt I...
-
EI think you can answer this as soon as you look at real world situations in your industry. How often do you have a case where a bottom...
-
EEH_SG replied to the thread Solved A normalisation question.Thank you all for your help so far - I hadn't had chance to come back to look at all your input until now. Kens BOM db does do what I'm...
-
EEH_SG replied to the thread Solved A normalisation question.Numerous Lookup field in numerous tables - why is this bad and what is the alternative? Some of your Joins between tables do not have...
-
EEH_SG replied to the thread Solved A normalisation question.I have tried to improve the relationships view to make it clearer how everything works together currently. I do have junction tables...
-
-
EEH_SG replied to the thread Solved A normalisation question.These tables log each stock transaction for inventory, sections and products respectively
-
EEH_SG replied to the thread Solved A normalisation question.Inventory, Sections and Products - each then has its own transactions table, which should maybe be 1 table also if I merge the initial three
-
EEH_SG replied to the thread Solved A normalisation question.This is a back up of the tables (only) I created before I moved them to sharepoint so its not exactly like this now but the structure is...
-
EI created a database for my employer 2 years ago, initially to track component stock though it has broadened to encompass more. It...
-
