multiple conditional value list

[markga]

Is it possible to make a value list conditional on the values from two different fields?

Example: I have a quotations file with quote numbers and revision numbers, I want to use the quote number then the revision number to determine the current price for the item (quote number 5, revison 3) in question.

Thanks!

I think I've found the answer in another forum.A calculated key is the solution. Create a calc in the quote file, quote number & "-" & Revision. Then put the quote number, followed by a "-" and the revison in the match field in the other DB to join them.

Does this sound right?

[This message has been edited by markga (edited September 01, 2000).]

[Kurt Knippel]

quote:

---

Originally posted by markga:

Is it possible to make a value list conditional on the values from two different fields?

Example: I have a quotations file with quote numbers and revision numbers, I want to use the quote number then the revision number to determine the current price for the item (quote number 5, revison 3) in question.

Thanks!

I think I've found the answer in another forum.A calculated key is the solution. Create a calc in the quote file, quote number & "-" & Revision. Then put the quote number, followed by a "-" and the revison in the match field in the other DB to join them.

Does this sound right?

[This message has been edited by markga (edited September 01, 2000).]

---

That is exactly the way to accomplish this.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Senior Filemaker Developer

http://www.database-resources.com

mailto:[email protected]

=-=-=-=-=-=-=-=-=-=-=-=-=