Value Lists out of portals

[Heathbo]

How do I make 1 value list based on the results of 2 portals?

[Søren Dyhr]

By gathering the ID's from each of portals via ValueListITems( and make it a new primary key for yet a relation. This multiline relation is used to make a dynamic valuelist...

--sd

[Heathbo]

I apologize for my ignorance on the subject, but how do you do that?

[aaa]

Can you show example where it is necessary?

[Søren Dyhr]

Can you show example where it is necessary?

Yes! It's pretty relevant to know if it's aspects of the same table-sets or entirely unrelated data. My method was supposed to work with different aspects of the same tables contents ...since the neither OR nor XOR operators between stacked relationship types exist, and only can work when convert your statement via DeMorgans Law.

If the wish is to mix itemID's from several suppliers, could it also make sence, provided that distinctive differences exists in the ID's ...the lists mixes into one but the from FM7 Lookup( function uses then it's ability to grap a value from table2 if no match exists in table1.

Before I start to make a template, do I wish to know which one of the scenarios we're talking about ...or if it's a third one???

--sd

[Søren Dyhr]

Since you're on mac OS could it alternatively be made this way, by googling yourself to diverse applescript snippets in the vicinity of these.

--sd

theGreengrosser.zip

[Heathbo]

I have two tables. The portals are in table 1 showing data from table 2. I want the value list to be in a pop up menu in table 1 showing a list of the value shown in the two portals.

[Søren Dyhr]

Alright same table different aspects of the same set of data, what is the purpose, seen from the users point of view, why is it required to gather the two into one??? The reason why I ask is that you might get the desired dynamic popup by stacking the relations in multicriteria instead, making my initial suggestion overkill.

--sd

[Heathbo]

Well, both portals show different types of data. For example Portal 1 shows fruit and Portal 2 shows vegetables. I just need to find a way to make a pop up list that will show all the data (Fruit and Vegetables) in it. It would be much better if its was a pop up list instead of a pop up window.

[Søren Dyhr]

Ok - The easiest way is to make it different aspects of same table, sometimes called:

"Tiered Tables" or "Multipurpose Tables"

Take a look at page 16 of:

http://www.codemastersworkshop.com/Downloads/WhitePaperForFMPNovices.pdf

See if you get the idea??? Otherwise let me know!!!

--sd

[aaa]

Hi, Heathbo! If your portals displays the same field from the second table why not such as in attachment.

Or your portals displays different fields from second table? Sory me if i dont understand you!

MergeList.zip

Edited November 2, 2005 by Guest

[Heathbo]

Thanks all, I figured it out.