AnsweredAssumed Answered

Marge two tables' date fields and use it in a Value Lists entry, Dynamically?

Question asked by YoshioOgata on Aug 10, 2014
Latest reply on Aug 12, 2014 by YoshioOgata

Title

Marge two tables' date fields and use it in a Value Lists entry, Dynamically?

Post

          Or How to convert list function's result to Value Lists?
           
     Hello and thanks everyone sharing great ideas and solutions.
      
     I am trying, without success, to use list function’s results into Value Lists.  I am appreciated if you share some knowledge or guide where I should do.
      
     Here is what I am doing;
      
     1) I have two individual tables, each of which contains unique date (in a date filed), sampling numbers and contained date are irreverent on each table.
     2) What I want to do is to marge two tables' date fields and use it in a Value Lists entry.  
     I want it to be updated dynamic, such as when new date entry is made, the Value Lists be updated accordingly, not every-time importing another table's field or performing scripts...
      
     3)What I came up with is to make use of List() function to get each field's contents as text, then to concatenate each, thus producing what I am intending.  
      
     This far I have come and stuck and need your guidance...
      
     what I want to do next are;
     4) How to convert this result (return delimited text) in to Value Lists.
     5) Additionally, it is quite helpful, if I can sort date.
      
     my working environments:  MacOSX 10.93, filemaker pro 13 advanced
      
     Thank you for your attention.
      
     Yoshio, Kyoto Japan
      

Outcomes