Jump to content

  •  

Photo

Pop-up Menu showing the values from different tables


  • Please log in to reply
12 replies to this topic

#1 Creek  novice

Creek
  • Members
  • 41 posts
  • LocationWarsaw
  • FM Application:12 Advance
  • Platform:Cross Platform
  • Skill Level:Beginner
  • Time Online: 5d 21h 30m 24s

Posted 25 November 2011 - 02:05 PM

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.

Attached File  joins.zip   6.63KB   18 downloads

Please explain to me, how to do it.
  • 0

#2 comment  consultant

comment
  • Members
  • 23,518 posts
  • Time Online: 299d 17h 38m 6s

Posted 25 November 2011 - 02:33 PM

Two possible ways:

Attached Files


  • 0

#3 Creek  novice

Creek
  • Members
  • 41 posts
  • LocationWarsaw
  • FM Application:12 Advance
  • Platform:Cross Platform
  • Skill Level:Beginner
  • Time Online: 5d 21h 30m 24s

Posted 25 November 2011 - 03:06 PM

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

#4 comment  consultant

comment
  • Members
  • 23,518 posts
  • Time Online: 299d 17h 38m 6s

Posted 25 November 2011 - 03:35 PM

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

Attached Files


  • 0

#5 comment  consultant

comment
  • Members
  • 23,518 posts
  • Time Online: 299d 17h 38m 6s

Posted 25 November 2011 - 04:46 PM

Here's yet another way to look at it:

Attached Files


  • 0

#6 Creek  novice

Creek
  • Members
  • 41 posts
  • LocationWarsaw
  • FM Application:12 Advance
  • Platform:Cross Platform
  • Skill Level:Beginner
  • Time Online: 5d 21h 30m 24s

Posted 26 November 2011 - 06:39 AM

Great three solutions

Thank you very much!
  • 0

#7 Creek  novice

Creek
  • Members
  • 41 posts
  • LocationWarsaw
  • FM Application:12 Advance
  • Platform:Cross Platform
  • Skill Level:Beginner
  • Time Online: 5d 21h 30m 24s

Posted 26 November 2011 - 07:41 AM

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.

Attached File  joinsBnew.zip   7.01KB   23 downloads
  • 0

#8 Lee Smith  Like v13 layout tools

Lee Smith
  • Staff
  • 9,851 posts
  • FM Application:13 Advance
  • FMGo:iPhone / iPod Touch
  • Platform:Mac OS X Mavericks
  • Skill Level:Expert
  • Membership:TechNet
  • Time Online: 199d 10h 43m 2s

Posted 26 November 2011 - 11:56 AM

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

#9 comment  consultant

comment
  • Members
  • 23,518 posts
  • Time Online: 299d 17h 38m 6s

Posted 26 November 2011 - 03:24 PM

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

#10 Creek  novice

Creek
  • Members
  • 41 posts
  • LocationWarsaw
  • FM Application:12 Advance
  • Platform:Cross Platform
  • Skill Level:Beginner
  • Time Online: 5d 21h 30m 24s

Posted 27 November 2011 - 02:30 AM

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

#11 comment  consultant

comment
  • Members
  • 23,518 posts
  • Time Online: 299d 17h 38m 6s

Posted 27 November 2011 - 05:09 AM

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

#12 Creek  novice

Creek
  • Members
  • 41 posts
  • LocationWarsaw
  • FM Application:12 Advance
  • Platform:Cross Platform
  • Skill Level:Beginner
  • Time Online: 5d 21h 30m 24s

Posted 27 November 2011 - 05:36 AM

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

#13 comment  consultant

comment
  • Members
  • 23,518 posts
  • Time Online: 299d 17h 38m 6s

Posted 27 November 2011 - 07:13 AM

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


  • 0




FMForum Advertisers