Jump to content

Drop down list blues!


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

Recommended Posts

  • Newbies

Hi there,

Please can you advise? I have a database with the fields "Category" and "Item". There are multiple categories. Each Item record is different, but some will have the same category next to them. I have a drop down list that lets me choose a category, but i would like to be able to choose in a second drop down an item that belongs in the category chosen in the first drop down.

Does this make sense?

Hope someone can help!

Thanks,

Mike

Link to comment
Share on other sites

  • Newbies

Brilliant, thank you very much for the link. Worked a dream. However I have another query. I have added the field ItemRef, and now i need that to display the associated value, based on what is chosen in the Item drop down box.

Hope it makes sense.

Thanks,

Mike

Link to comment
Share on other sites

  • Newbies

Please see attached examples. I attach sample of the table, and a sample of the layout. In the layout the "Category" chosen does now create a relevant value list for the "Item" field. If you notice below the "Item" box is a "ItemRef" box, I would like that to show the "ItemRef" for the item, "ItemRef" is also a unique number.

 

Mike

TableExample.JPG

LayoutExample.JPG

Link to comment
Share on other sites

This topic is 2583 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.