thierry2014
New member
- Local time
- Today, 11:39
- Joined
- Aug 23, 2016
- Messages
- 2
Hello,
A great forum everyone......I haven't used access for many years now, and I'm gradually getting into the swing of it again!
I've been tasked with creating a simple stock/outwork database, and I'm struggling to get to grips with what I need to do regarding tables, relationships and creating forms for the front end..... so here goes (sorry about the length of this!)
OK, I want to create a database of automobile nets.....
Raw Nets (unmanufactured) - There are 11 colours of varying styles of net (but only 3 types of style which are map,wide & armrest)
Wires come in as raw stock also - there are 3 types of this to match the style (map, wide & armrest)
So there are 33 possible colours/style of net and 3 styles of wire........(bare with me!)
19 employees take home (each week) a quantity of nets (of the 33 possible combinations) plus the wires to match the type of net they have and make this up returning varying amounts to the warehouse each day......
They are allocated, say 1000 of a certain type and are given more when finished.....
Each employee is paid for completed nets returned within a pay week (which is Thursday to Wednesday) and I need a report to show this (with the option to select and record dates of these returns etc)
A report is also required to show each type of net to show:
1) Current raw stock total (option to update this when new raw stock comes in)
2) Each style combination that is currently with an employee (for outwork)
3) Returned/Completed net quantity (option to reset this to 0 when actually sent out to customer)
An employee would need to (using user forms from the front end) update raw stock and allocate nets to each person as well as update it when nets are completed as well!)
Any pointers, or help with structuring this would be very helpful to me indeed to get some sort of system working!
Currently, we use a notebook to record all this!!!!
I've tried to explain what I'm after the best I can so apologies if this doesn't make much sense!
:banghead::banghead::banghead:
Many thanks.
Craig
A great forum everyone......I haven't used access for many years now, and I'm gradually getting into the swing of it again!
I've been tasked with creating a simple stock/outwork database, and I'm struggling to get to grips with what I need to do regarding tables, relationships and creating forms for the front end..... so here goes (sorry about the length of this!)
OK, I want to create a database of automobile nets.....
Raw Nets (unmanufactured) - There are 11 colours of varying styles of net (but only 3 types of style which are map,wide & armrest)
Wires come in as raw stock also - there are 3 types of this to match the style (map, wide & armrest)
So there are 33 possible colours/style of net and 3 styles of wire........(bare with me!)
19 employees take home (each week) a quantity of nets (of the 33 possible combinations) plus the wires to match the type of net they have and make this up returning varying amounts to the warehouse each day......
They are allocated, say 1000 of a certain type and are given more when finished.....
Each employee is paid for completed nets returned within a pay week (which is Thursday to Wednesday) and I need a report to show this (with the option to select and record dates of these returns etc)
A report is also required to show each type of net to show:
1) Current raw stock total (option to update this when new raw stock comes in)
2) Each style combination that is currently with an employee (for outwork)
3) Returned/Completed net quantity (option to reset this to 0 when actually sent out to customer)
An employee would need to (using user forms from the front end) update raw stock and allocate nets to each person as well as update it when nets are completed as well!)
Any pointers, or help with structuring this would be very helpful to me indeed to get some sort of system working!
Currently, we use a notebook to record all this!!!!
I've tried to explain what I'm after the best I can so apologies if this doesn't make much sense!
:banghead::banghead::banghead:
Many thanks.
Craig