Related Filtered field
Hello,
I have an app where I have two tables for Location Codes. One is a sync up with SAP for All active Location Codes and the second table (Location Code request) has a form to Change or request...
Forum Discussion
Hello,
I tried to use a Formula Query hoping to pull up the corresponding record from the Location Code request table. My query is as shown below:
GetFieldValues(GetRecord([Location Code in Process RecID],[_DBID_REQUEST_A_NEW_LOCATION_CODE]),103)
where [Location Code in Process RecID] would be the corresponding Record in Location Code request table
but get an error
This is my first time using a Formula Query. What am I doing wrong?
Thanks!
------------------------------
Deepa Prashant
------------------------------
Hello,
I am making progress! I was able to get my formula query to work by just converting the type to text. But how do I now take a snapshot of either [Location Code in Process RecID] or the actual Record in Location Code request table which gets pulled up initially upon choosing the in-process location code? Once the in-process location code gets marked as completed, that value will disappear and so will the formula query value?
Thanks!
------------------------------
Deepa Prashant
------------------------------
Figured this one out!!
Created a snapshot of the original related field and changed my formula query to use that. Worked like a charm.
Sometimes it helps to write out your question. :-)
------------------------------
Deepa Prashant
------------------------------