-
What is the actual value of a choice field
I'm trying to display the number of records with different values in a choice box in a linked table over multiple records. When I run the following code I should get Pa 28 Fa 1 No 0 but I just get 0,…
-
Is it possible to use the find field to find a formula field?
It's looking like its not since the global search option isn't available for formula fields. I tried to do a work around by updating a number field automatically on create or on update of the table.…
-
Need help automatically linking tables.
I have the following code. Explanation below. let current := Id;for j in (select Workorders).'Related Equipment'.Equipment dolet Newinspectionsheet := (create 'Inspection Sheet');Newinspectionsheet.…
-
I need help with a table relationship.
I'm having trouble figuring out a complicated relationship for linking. Any help would be appreciated. I have Customers->Locations->Equipment->Tasks->Workorders I'm trying to find a solution to link…
Latest Posts

