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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

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