Conditional value list will not work in find mode

[Mark Appleby]

I am having a problem with my value list. It is conditional and works when entering a new item. My problem is that I have a different form for crating a find request, the same value list will not work on this file. Why not? I can see no reason. Has anyone any experience of this?

[falkaholic]

Which method are you using to make the list conditional?

[Mark Appleby]

Basically, I am trying to limit choices by Department Name, Related catagories, Related subcatagories. What I can not understand is that exactly the same value list works when creating a record but not on the different layout when trying to do an enquiry.

My relationships are Style is related to one department. Each Department has many Catagories related by department. Each Catagory has many Subcatagories, These are related by a stored calculation "Dept&Catagory".

My Value list is is based upon the relationship of Catagories to subcatagories.

Have you any ideas?

[Keith M. Davie]

Are you trying to accomplish a search of three fields ("Department Name", "Related catagories", "Related subcatagories")?

[Vaughan]

When in Find mode you don't have any records selected, that may be the cause of the problem. Try inserting the value into glbals and see if that works...

[Mark Appleby]

Vaughn

How do I put these values into globals? Do you mean create three globals? Also How can I do a calculation in a global?

BTW has your beautiful portrait gone forever?

[Mark Appleby]

Keith,

Very of ten I am trying to search on three fields. Sometimes even more. We have some areas that have in excess of 5000 stock items.

[djgogi]

You just have to activate all relationships you need for selecting value from the list, IOW you can't enter search criteria in third value list before setting value list 1 and 2.

if the first value list is also relational than you should also activate its relationship.

Dj

[Mark Appleby]

How can I activate these relationships in find mode?

[Vaughan]

You might not have to.

Create global fields, as many as you need. In browse mode get the user to enter the "find" data with the value lists into the global fields, then run a script that changes to find mode, copies the global values into the "real" fields and performs the find.

[djgogi]

How about posting your file here?

However I don't see the problem, unless you are trying to select value from the list that wasn't been initiated yet.

For example let's say you have two lists: makes and models where obviously model depends on make.

If you try to access models without selecting make you won't get anything to choose from.

So if you want to find for ex, Ford Mustang you'll need first to select make (Ford) and than choose model Mustang and finally perform find

HTH

Dj

[Mark Appleby]

Dj,

Your Idea worked. I have managed to get the find to work. I made a new value list which inserted the matching field into catagories this enables me to get the shorter sub catagories list. I don't know why I didn't spot this before. The value list will not look quite as obvious though for the user as the match field between department and catagory is just a stored calculation. "Dept&Cat" although I do have the list sorted by it's description.

[djgogi]

My suggestion (at least it's what I'm using for lists in find mode ) is to create separated lists for find that use values from field so that only present values would be visible and hence facilitate find.

Dj