conditional value list question

[Gabe]

I have a drop down box on a layout that needs to display a list of values from one of three different tables based on the value of another field on the layout.

For example, there is a drop down box called "person type" which can be either P for party, W for witness, or A for attorney. When P is selected, I want to poulate another specific menu with names of related parties, and so on.

I already have a lookup table set up that contains a calculation field which looks up and returns the name value from one of the three member tables based on the value of the person type field. So when I set a person type, and then the id field to an existing value, it shows me the name associated with the id from the desired table.

I think what I really need to know is if it is possible to return a list of related values (repeating maybe?), and how to fit those values into a value list.

[Gabe]

I have a drop down box on a layout that needs to display a list of values from one of three different tables based on the value of another field on the layout.

For example, there is a drop down box called "person type" which can be either P for party, W for witness, or A for attorney. When P is selected, I want to poulate another specific menu with names of related parties, and so on.

I already have a lookup table set up that contains a calculation field which looks up and returns the name value from one of the three member tables based on the value of the person type field. So when I set a person type, and then the id field to an existing value, it shows me the name associated with the id from the desired table.

I think what I really need to know is if it is possible to return a list of related values (repeating maybe?), and how to fit those values into a value list.

[Gabe]

I have a drop down box on a layout that needs to display a list of values from one of three different tables based on the value of another field on the layout.

For example, there is a drop down box called "person type" which can be either P for party, W for witness, or A for attorney. When P is selected, I want to poulate another specific menu with names of related parties, and so on.

I already have a lookup table set up that contains a calculation field which looks up and returns the name value from one of the three member tables based on the value of the person type field. So when I set a person type, and then the id field to an existing value, it shows me the name associated with the id from the desired table.

I think what I really need to know is if it is possible to return a list of related values (repeating maybe?), and how to fit those values into a value list.

[Vaughan]

Off the top of my head I'll ask why the P, W and A people aren't all in the same table, with a field to distinguish them. Making the conditional value list would then be a snap.

[Vaughan]

Off the top of my head I'll ask why the P, W and A people aren't all in the same table, with a field to distinguish them. Making the conditional value list would then be a snap.

[Vaughan]

Off the top of my head I'll ask why the P, W and A people aren't all in the same table, with a field to distinguish them. Making the conditional value list would then be a snap.

[Gabe]

Hrmm. Well, I didn't think of that when I started putting the thing together. I was loosely following the database layout of the old program that I am replacing, mostly so that it would be as easy as possible to migrate the data. I didn't have enough knowledge of filemaker at that point to have very good foresight.

At this point I'd have to throw away a big bulk of work if I were to consolidate the tables. I don't really want to consider doing it that way, even if it means pulling my hair out to get this new problem solved.

I guess what I'm going to do is try to guage what other problems could come up if I go ahead and do it your way. In the meantime, however, do you have any suggestions on how I might do it my way?

[Gabe]

Hrmm. Well, I didn't think of that when I started putting the thing together. I was loosely following the database layout of the old program that I am replacing, mostly so that it would be as easy as possible to migrate the data. I didn't have enough knowledge of filemaker at that point to have very good foresight.

At this point I'd have to throw away a big bulk of work if I were to consolidate the tables. I don't really want to consider doing it that way, even if it means pulling my hair out to get this new problem solved.

I guess what I'm going to do is try to guage what other problems could come up if I go ahead and do it your way. In the meantime, however, do you have any suggestions on how I might do it my way?

[Gabe]

Hrmm. Well, I didn't think of that when I started putting the thing together. I was loosely following the database layout of the old program that I am replacing, mostly so that it would be as easy as possible to migrate the data. I didn't have enough knowledge of filemaker at that point to have very good foresight.

At this point I'd have to throw away a big bulk of work if I were to consolidate the tables. I don't really want to consider doing it that way, even if it means pulling my hair out to get this new problem solved.

I guess what I'm going to do is try to guage what other problems could come up if I go ahead and do it your way. In the meantime, however, do you have any suggestions on how I might do it my way?

[Gabe]

All I really need to know to fix the problem is if I can use a calculation field to populata a value list some way.

[Gabe]

All I really need to know to fix the problem is if I can use a calculation field to populata a value list some way.

[Gabe]

All I really need to know to fix the problem is if I can use a calculation field to populata a value list some way.