Constant value in relationship (field = "abcd")

Idea created by tomasd on Oct 27, 2015
    Active
    Score109

    If I have a relationship in Filemaker, both sides of the relation need to exist as a field in filemaker table.

    Condition can be defined with 'constant' (for example State = 'Active' or isChecked = 1). Each constant has to be defined as a field in order to be used in the condition (we are using indexed calculation or global field). It could be easier, if we can define the constant outside database fields definition or if we could directly write the constant into the condition. Constant defined as field adds 'clutter' into a database table and it has to be stored for each record and table.