Help With DB

[1eye1vision]

I really need help with my db, i created a stores issue db which was working well until one of the bosses decided he wanted the way it works to change, the thing is i haven't a clue where to start. The way it issues stores at present is singular, however the boss now wants this to be multiple issues to one person on a single form. The thing is it took me 4 months to build the db and i don't really want to start from scratch again and was wondering if anyone out there could have a look at the db and see if there is a way to change this without starting again.

i had an idea on how this might be acheived, but not all that good at putting it into practice.
The idea was that you have a form with all the list of stores you have and on that form you have also a combo box with the list of persons you issue to. Then by using a multi select, you select the items you want to issue and then using an append query copy these items to the stores issue form. so that way if you wish to remove these items from a persons record all you have to do is reverse the action and remove them from the issue form.

However as stated at the start, its ok having an idea but putting it into practice is a different matter.

I have added the structure of the db

 

[1eye1vision]

!!!bump!!!

 

[RuralGuy]

What are "stores issues"? I'm not familiar with the term. It would also have been of considerable help if you could have included the "singular" method in your sample db. Then we could see how much needs to be done for each "issue".

 

[1eye1vision]

i Havent attached the full db as it was too big to upload, however if you would like i can pm you the details to get the full db from my yahoo briefcase.

 

[RV]

Best approach is to adapt your database structure.
You'd have to anyway.
Your approach in itself is not too bad in such that you seem to understand your business processes.

However, your designed is not properly normalized and will definitely cause difficulties storing and retrieving data.
In fact, you just ran into the first "difficulty" right now.

Apparently, you've got multiple stores.
That means that an item can be held at multiple stores and a store can hold multiple items.
In other words, you've got a many on many relation, to be normalized by adding a junction table.

Looking at your sample, I suspect you could do with more normalisation.
Can't tell though as apparently you haven't zipped a full copy of your current applic.

i Havent attached the full db as it was too big to upload

Strip it, and leave some data.
Most forummers don't do PM's....

RV

 

[1eye1vision]

Many Thanks to Rural Guy for helping and sorting the problem out, you guys really need to ask this guy for help SUPERB, couldn't have done more for me. A+++++++

 

[RuralGuy]

Thanks for the post. I'm sure all of us enjoy reading that kind of stuff. I know I do! I enjoyed the challenge.