July 17, 200520 yr Hi! Could someone point me in the right direction with this? I've brought it as close as possible and attached an example (pick one, .zip or .sit)... Two tables: Workers and Tasks. Workers (field initials) have multiple Tasks. Tasks have a status of A, B or C. I want a portal that displays all of a worker's records with a particular status. In the attached example, change the value of the valuelist (the yellow field) in workers.fp5. The calculation in tasks.fp5 (the blue field) changes appropriately, but can't be used in the portal relationship because something won't index. How do I create a relationship based on a calculation that contains a global? This works beautifully in FMP7 but not 6... Thanks for any advice! N tasks.fp5.zip
July 17, 200520 yr Multi-criteria relationships in 7 equal single-criterion relationships using compound fields in 6. First, move gLimiter to the Workers table; it is not needed in the Tasks table, for this relationship. Then, create a calculated text field in Workers of initials & " " & gLimiter Do the same in Tasks with a calculation of initials & " " & status Now, change your relationship from Workers to Tasks to relate the first calculation (which will be unstored, due to the global) to the second (which will be indexed).
Create an account or sign in to comment