AnsweredAssumed Answered

Conditional Value List

Question asked by ShaoLiang on Mar 26, 2013
Latest reply on Mar 27, 2013 by ShaoLiang

Summary

Conditional Value List

Product

FileMaker Pro

Version

12

Operating system version

Windows

Description of the issue

In the relation (Customer <-> SalesOrder <-> SalesOrderLineItem <-> QuoteLineItem), I would like to call the QuoteLineItem from SalesOrderLineItem by using Pop-up Menu. The Pop-up Menu gives all the QuoteLineItems and I onlt want to show the QuoteLineItems related to that Customer. I tried many ways to do it. Nothing works right for me.

Steps to reproduce the problem

[Customer] and [SalesOrder] are related by CustomerID;
[SalesOrder] and [SalesOrderLineItem] are related by SalesOrderID;
[SalesOrderLineItem] and [QuoteLineItem]are related by QuoteLineItemID and CustomerID;

Expected result

In the Pop-up Menu, I choose the "Include only related values...". I should be able to load all the item info into the SalesOrderLineItem.

Actual result

In the Pop-up Menu, I choose the "Include only related values...". I couldn't load all the item info into the SalesOrderLineItem. I guess that is due to the double relation of QuoteLineItemID and CustomerID. Any better way to do it?
Thanks,

Exact text of any error message(s) that appear

no error message

Relation-2013-03-26.jpg

Outcomes