Sign in to follow this  
Followers 0

Pop-up Menu showing the values from different tables

13 posts in this topic

Posted

I have three tables. TabA, TabB, TabC

I set relationship : TabA >--- TabB >--- TabC

I created a portal based on TabA_self. I want to display a some field from all tables. I have no problems with the TabA and TabB. I do not know how to display field "ParameterC" from the table TabC.

Copy database in the attachment.

joins.zip

Please explain to me, how to do it.

0

Share this post


Link to post
Share on other sites

Posted

Two possible ways:

joinsA.zip

0

Share this post


Link to post
Share on other sites

Posted

Thank you for your prompt reply.

Unfortunately your solution does not work for me.

In columns "ParameterC" and "c ParameterB" I see values from „ParameterB” (TabB). This is mistake. ParameterC is in TabC.

Could you please, check it?

0

Share this post


Link to post
Share on other sites

Posted

It doesn't really matter - the principle is the same:

joinsB.zip

0

Share this post


Link to post
Share on other sites

Posted

Here's yet another way to look at it:

joinsC.zip

0

Share this post


Link to post
Share on other sites

Posted

Great three solutions

Thank you very much!

0

Share this post


Link to post
Share on other sites

Posted

This thread is a continuation of http://fmforums.com/...on-one-to-many/ Now I have another problem

I have three tables. TabA, TabB, TabC

I set relationship : TabA >--- TabB >--- TabC

How to create pop-up menu showing ParameterB from TabB and ParameterC from TabC?

Copy database in the attachment.

joinsBnew.zip

0

Share this post


Link to post
Share on other sites

Posted

This thread is a continuation.......

I have Merged your two threads. Please DO NOT multiple post your questions. A follow up question should always be posted as a Reply to the Original Thread.

TIA for your cooperation

Lee

0

Share this post


Link to post
Share on other sites

Posted

How to create pop-up menu showing ParameterB from TabB and ParameterC from TabC?

It's not possible to have a value list showing values from two different fields in two different tables. Why would you need this?

0

Share this post


Link to post
Share on other sites

Posted

It is very sad and strange. Ok. I will present my situation.

I have three tables. Orders, Bank Accounts, Currencies

Orders>--- Bank Accounts>--- Currencies

I have inserted pop-up menu in layout (Orders). This pop-up menu sets fk_id_bank_account. I set in window “Specify Fields for Value” First field – id_bank_account (from Bank Accounts), Second field – iban (from Bank Accounts). It works great but is not sufficient. User will not remember which currency is set for which account.

Therefore I created calculation field (popupinfo) in the table Bank Accounts. Now I set (iban & „ „ & short_b_name). Now, I would like to add information about the currency.

In an earlier version of my little project I didn't have a table Currencies. I used popup-menu with “custom values” (USD, EUR, CHF). (Popupinfo = iban & „ „ & short_b_name & „ „ & currency)

In this version I had no problem with displaying above data. Problem appeared only when I replaced popup-menu with “Currencies” table.

0

Share this post


Link to post
Share on other sites

Posted

I am not sure what the problem is. You can make the calculation field in the BankAccounts table =

iban & " " & short_b_name & " " Currencies::Currency

and use it the second field in your value list - as long as you don't try to sort the values by the second field.

Alternatively, you could use the currency symbol as the match value for the Currencies -< BankAccounts relationship.

0

Share this post


Link to post
Share on other sites

Posted

iban & " " & short_b_name & " " & Currencies::Currency

I checked it earlier. It doesn't work :(

I replaced two messages:

"This value list will not work because the field "popupinfo" cannot be indexed"

pop-up menu displays <Index Missing> :(

0

Share this post


Link to post
Share on other sites

Posted

as long as you don't try to sort the values by the second field.

0

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0