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.

Two possible ways:

joinsA.zip

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?

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

joinsB.zip

Here's yet another way to look at it:

joinsC.zip

Great three solutions

Thank you very much!

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

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

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?

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.

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.

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> :(

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