Thanks a lot! It worked with a little change:
Assuming the table is like u mentioned above.
'Original' as Key
where Original = 'Original'
Concatenate (Table 1)
'Split' as Key
where Split= 'Split'
[Original or Split?]:
Resident Table 1
Just a question. Is this the optimal way of doing this? Concatenating tables like this is creating a table twice as big as the original.
Hi Peter, another option can be creating a concatenated Key:
LOAD Split &'|'& Original as SO_Key
//Create the related table
[Original or Split]:
LOAD FieldValue(SO_Key, RecNo()) as SO_Key,
Subfield(FieldValue(SO_Key, RecNo()), '|', 1) as Split
Subfield(FieldValue(SO_Key, RecNo()), '|', 2) as Original
You could try setting a variable under a button Optional or Split. then in your sheet objects you can alter how the object behaves accordingly using the variable rather than a filter.
Ive attached an example of it working in action. Although I think the two suggestions you have already been provided with are easier to implement. Depends if you want to limit the behaviour to just part of an app or the whole of it. If its all the app then filtering will be the way to go.