Suppliers and Products

[beanie_d83]

Ok, so I have created a table which will eventually contain all the information about the suppliers to my company. Some of them will only supply us with the odd product every now and then whereas others supply us with several different products on a monthly basis.

I would imagine that I require a separate table in which to store all the different product information (part numbers, costs, etc) but how would I link each individual product to the respective supplier?

Forgive me if this may seem obvious to many of you, but I am only a beginner!!

Many thanks!

 

[jdraw]

Since you are a beginner, I recommend you read the following and understand What a relational database is and how one is designed.
http://forums.aspfree.com/attachment.php?attachmentid=4712&d=1201055452

Once you have a handle on the Principles, this second article will help you construct your tables and relationships
http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip

These articles are basic to relational data base.
Good luck with your project.

 

[beanie_d83]

Well, to say that I am a complete beginner might be bending the truth a little. I studied ICT while at college and where I had my first encounter with Access.

This was some 13 years ago now and I haven't had a job position where I have needed to use Access until now so as you might imagine...I'm a little rusty!

Anyway, thank you so much for the links to the articles, I shall read these carefully and with any luck my memory may get jogged and all will start coming back to me!

 

[jdraw]

Better to start with these 2 articles than trying to start with a physical table or form.

If you need more info on the processes generally in video format here is a link to some videos I recommend to people on a different forum. See post#2 here
http://www.accessforums.net/access/help-building-forms-30979.html