Forum Discussion
Ivan__Torr
Jan 18, 2021Copper Contributor
Access stock taking system
I have created a stock system with all relevant tables .My system can purchase products from relevant suppliers via email. I am trying to create a system from this that can do a stock count ( ie Ph...
George_Hepworth
Jan 18, 2021Silver Contributor
While you've done a good job of introducing the CONCEPT, there isn't really enough detail in that description to offer any suggestions. "...all relevant tables..." could mean a number of different things to different people, for example. And none of them would be able to do much with that anyway because we wouldn't know if OUR assumptions matched the reality.
Let's start with a relationship diagram. That'll get us started being able to ask you useful questions about the system and maybe lead to some suggestions.
Thanks.
Ivan__Torr
Jan 19, 2021Copper Contributor
See attached. Sorry new to Access. Its amazing what Covid get a person up too.
It is a Recipe and Dish coster . It also does allergens and Calorie counts on each dish.
hope this helps