This topic is 2589 days old. Please don't post here. Open a new topic instead.
I have been working FileMaker for 22 years and building custom web systems for the last 8 years in PHP/mySQL. Recently, my company has hit a dry slump (a few larger projects have pause development and the projects in the pipe are delaying) and I am current putting out a few feelers letting people know I am available for sub-contracting or a sharp shooter to get you over the hump.
Please contact me PRIVATELY, if you are interested in my services. Thanks!
Hello everyone, good evening!
I am a freelancer from the Philippines. I just have a question. Where can we find websites that offers work as a FileMaker Developer?
Thanks and God bless!
It appears my request for help in the Value List forum ( https://fmforums.com/topic/103348-conditional-value-list-multiple-fields-in-another-table/ ) might be a little too involved to ask someone to tweak it for free so I'm going the "for hire" route to get it to worked on; please respond with your bid by mailing it rstuart @ lcsc.edu (sans spaces).
To access the attached file, the account name and password are the same: admin
What I want to do is have Company_CAD_Abbreviated__lxt field's use a conditional value list to present values using Company_CAD_Type__lxt and Company_CountryAbbreviated__lxt as keys/filters. For example, if Company_CAD_Type__lxt = ST and Company_CountryAbbreviated__lxt = US, then Company_CAD_Abbreviated__lxt should only show the fifty US states; if Company_CountryAbbreviated__lxt is empty, then Company_CAD_Abbreviated__lxt's value list should show all the values that have ST for Company_CAD_Type__lxt.
Another example would be if Company_CAD_Type__lxt is PROV and Company_CountryAbbreviated__lxt = CA, then Canada's provinces should appear in Company_CAD_Abbreviated__lxt's value list; if no value is entered in Company_CountryAbbreviated__lxt then Company_CAD_Abbreviated__lxt's value list should show all the values that have PROV entered for Company_CAD_Type__lxt.
If no value is entered in Company_CAD_Type__lxt then all the value will appear in the Company_CAD_Abbreviated__lxt's value list.
My preference is to code the fix in e-SQL, if possible.
Thanks in advance for your considereration; e-mail me if you have any questions.