I have a value list which uses a global field as its 'starting point'. (The global is the current user id, set in the startup script, and the value list is of the records to which that user has access.)
This is the definition of the VL, where GUI is the interface table (containing the global user id), PTY is the 'Activity Types' table, and UPA the join table defining the user's access:
Most of the time, everything's fine. But sometimes, the value list is not displayed correctly - it's empty, suggesting there's something wrong with the relationship, the definition of the VL, or the context (although I'm hoping that the use of the global makes it context-independent). Possibly relevant is that this is a separated solution - GUI is in the 'interface' file, other tables in 'data'.
I really need to know what makes it go wrong (and right!), so any pointers gratefully received.