Conditional Value List with multiple conditions

[valhalla]

OK I am having trouble setting up a value list as follows:

It is for a list of computer components (A long varied list) I would like the user to be able to select the type (monitor, printer, scanner etc.) then the next box will show all matching manufactures of that product (HP, Panasonic etc.) then finally they get a final box that contains all the models that match both type and manufacturer.

Thanks

[QuinTech]

Hi, valhalla, and welcome to FM Forums! Take a look at this link and see if that answers your question. If you're not using version 7, the answer will be different. (Please update your profile so we know what FM version you are using!)

HTH,

Jerry

[valhalla]

Thanks for your link, I had searched but had not fond exactly what I was lookig for. The solution you gave works well, except for one thing:

If I select printers the next box will correctly show say samsung and HP as options, Then I select HP and the next box will show only yhe HP printers. That works fine the problem is that as the selection is global when I move to a new record (that say I had a monitor-diamondview-17inch set up) it selects the first two boxes as whatever I last selected in this case priters and HP. Am I making any sense and is there a way I can get it to either store this info for each record or at least look it up based on the final part of the selection.

Thanks

[QuinTech]

Absolutely, you are making sense. What you're describing is a limitation only of the example i had posted. The "Chooser" fields as i had designed them were global. However, you can make them non-global and they will work exactly the same, except that the values will be different for each record.

J

[valhalla]

Ah of course, I thought that might screw things up so I didn't try it :

Thanks

[valhalla]

Zoiks now I am having all sorts of problems... Should I mabye put the selections in a seperate table to the list of equipment? That might work, but I can't quite get my head around it at the moment, I think I'll go have a break for a while.

[QuinTech]

What sorts of problems? Whether the selection fields are in a separate table or not will be a logical choice depending on your needs. This function should work in either case.

J

[laker_42]

QuinTech,

I am trying to use this same procedure but do it between two different tables. I have a SoftwareLicense table that has a SoftwareId & LicenseKey field. I created a self join relationship based on SoftwareId. I have a second table called SoftwareInstalled. In this table I have a SoftwareId field, a LicenseKey field and a ComputerSerialNo field. After I enter in a SoftwareId, I would like the LicenseKey value list to only show the LicenseKeys valid for the SoftwareId I entered in. No matter what I try, nothing is showing up in my value list. I did test my value list in the SoftwareInstalled table and it did exactly what your example does. Now I would like it to do the samething in the SoftwareInstalled table. Do I need to tweak your procedure in order to get this to work? Any help would be appreciated.

Thanks!

John

[laker_42]

Never mind, I figured out what my problem was. I had my relationship between the two tables based on LicenseKey. I added another TO and related that TO to the SoftwareInstalled table based on SoftwareId. I then did a self join on the new TO and based my value list on that relationship. I couldn't change the first relationship from LicenseKey to SoftwareId because of other rules that I need to abide by for this application. Thanks for the example you provided.

John