Jump to content

  •  

UPGRADE DEADLINE - SEPTEMBER 26, 2014!
FileMaker Inc. has a deadline for users of version 10,11, 12 as Individual box or volume licenses (with expired maintenance).
If you don't renew your maintenance and upgrade to FMP 13 you will no longer be eligible to upgrade, at the discount pricing.

Volume Licensing upgrade pricing for FileMaker Pro 13, FileMaker Pro 13 Advanced and FileMaker Server 13 will be discontinued.
Individual upgrade pricing for FileMaker Pro 13 and FileMaker Pro 13 Advanced will increase after September 26, 2014.
As of 27-September-2014, FileMaker 10 products will no longer be available for purchase or support.

http://help.filemaker.com/app/answers/detail/a_id/13865


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
  • 24,185 posts
  • Time Online: 328d 23h 41m 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
  • 24,185 posts
  • Time Online: 328d 23h 41m 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
  • 24,185 posts
  • Time Online: 328d 23h 41m 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  I like the v13 layout tools

Lee Smith
  • Staff
  • 10,142 posts
  • FM Application:13 Advance
  • FMGo:iPhone / iPod Touch
  • Platform:Mac OS X Mavericks
  • Skill Level:Expert
  • Membership:TechNet
  • Time Online: 228d 20h 56m 30s

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
  • 24,185 posts
  • Time Online: 328d 23h 41m 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
  • 24,185 posts
  • Time Online: 328d 23h 41m 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
  • 24,185 posts
  • Time Online: 328d 23h 41m 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