Value Lists +field

[Heathbo]

OK, I have a regular field with a pop up list that gets its value list from a relationship with another table. What I need to find a way to do is, in the other table (table 2), along with the name of the records there is another field titled "point value". In the point value field there is just a number. In the first table (table 1) there is the field with the pop up list and another field titled "points". What I want to do is, when I select a record from the pop up field in table 1, I want the corresponding value from the "point value" field in table 2 to show up in the points field.

Does anyone know of a way to do this. Any help you can give is much appreciated.

[Genx]

...my suggestion...

relate the table where your getting your value list from to the table where your popup list is by the values that are popping up in the pop up list... then make a calculation field who's result is: Popuplisttable::points (this would make much more sense if you had given some table and field names)

Edited September 26, 2005 by Guest

[Heathbo]

OK, I did this. But how do I link it to the pop up list so if the record in the pop up list changes the value in the points field changes?

[Genx]

ok, for the purpose of explaining this again im gonna make some table and field names up...

Table 1, will contain the pop up list field known as "popup" and the calculation field known as "point"... Table 2 will contain the popuplist options stored in a field known as "popup option" and the corrosponding point value stored in a field called "CPV" for each popuplist option...

We relate table 1 to table 2 by making a relationship between "popup" and "popup option".

Then we make the calculation result of "point" a text one, and make the calculation itself = Table 2::CPV ...

Finally, go into storage options and make sure that the box that has the following text next to it is ticked "do not store calculation results, recalculate when needed".

Hope this helped, genx

Edited September 27, 2005 by Guest

[Heathbo]

Awesome, thank you so much. FileMaker and this website never ceases to amaze me.

[Carmelo]

I am also having similar problems and cannot find a fix for it........if anyone has any help for this:

I have a table with Equipment and Equipment hourly rates....names equipmentName and equipmentPrice.....

On my second table I equipmentName1, equipmentName2, etc.... In those fields I have a drop down list that pulls up the list from Table 1 "equipmentName". I also have a field for equipmentQty, which asks the user to input the number of hours ran for the equipment and then in turn hopefully take the equipment hourly rate from table1 * qty from table 2 and spits out an answer into equipmentPrice.

I have it working 5%, if I put three different pieces of equipment on the list, and it keeps the first value of equipment1's price and applies it to equipment2 and equipment3, doesn't change equipmentPrice for each value.

I hope I explained it correctly. Thank you for your time.

Carmelo