Jump to content

Advice please........


lesley1160

This topic is 7088 days old. Please don't post here. Open a new topic instead.

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

Lesley

Link to comment
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.

Link to comment
Share on other sites

This topic is 7088 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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