Jump to content
Sign in to follow this  

Advice please........

Recommended Posts

Please could someone help me? I am trying to design my first database and have two files. One called Suppliers and one called Stock.

I have been trying to create fields which will show specific stock details (order number, stock description etc.) if a certain company name is selected. I have created a Value list for the stock details but how can I separate the information into the individual Suppliers ?

Many thanks


Share this post

Link to post
Share on other sites

Give each supplier a unique identifing code or number -- an auto-entered serial number is easiest. Put this into its own field.

Then, mark each stock item with the unique code for its supplier. This needs to be in its own field.

You can use these two fields to create a relationship between suppliers and stock. This relationship can be used to display each supplier's related stock in a portal.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.