Tailoring a value list

[Alexander198]

I am trying to create a value list based one field depending on the entry in another.

I.e. I want to create a value stock list of items by make in a shop. However once the item has been sold it still has to stay in the database. But if the value list is based on the makes field the sold item still comes up.

How do I get round this?

[jasonwood]

Seeing as no one else has responded, I guess I'm not the only one that didn't understand...

What do you mean by "value list"? That is the name of a feature in FileMaker... or are you referring to something else? Could you tell us what you are actually trying to accomplish? That might be easier.