Hi all
I am setting up a database to which will help me order parts from several suppliers into an orderform/s etc
My first problem:
I wish to set up several 'Kits' which will be made up of several parts - when I select a 'Kit' I want all the items of the 'Kit' to be entered into the orderform seperately.
Secondly:
The parts of the Kits that I am making up are to be ordered from several suppliers - thus several orders need to be produced from one 'Kit'/selection.
So how do I set up my tables etc to make all this happen?
Can this be done in Access - I love this program - exciting!