Jump to content
Sign in to follow this  
Creek

Pop-up Menu showing the values from different tables

Recommended Posts

Creek    0

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.

Share this post


Link to post
Share on other sites
Creek    0

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?

Share this post


Link to post
Share on other sites
Lee Smith    144

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

Share this post


Link to post
Share on other sites
comment    1,368

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?

Share this post


Link to post
Share on other sites
Creek    0

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.

Share this post


Link to post
Share on other sites
comment    1,368

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.

Share this post


Link to post
Share on other sites
Creek    0

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

Share this post


Link to post
Share on other sites
comment    1,368

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

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  

×

Important Information

By using this site, you agree to our Terms of Use.