I have a table (variation) which is linked to another table (variation items). As I need to open different variation form item depending on the value on the parent form, is there a way, I could achieve this? I have two forms created in the child table.
URLRoot() & "db/" & [_DBID_CHILD] & "?a=API_GenAddRecordForm&_fid_21=" & URLEncode ([Record ID#])&In the section in bold above, DFID is the parameter that identifies the Form the user will be shown. In the IF statement, I've just used an example, but the 2 and 10 are the Form ID's found in the table.
"dfid=" & IF([Criteria Field] = 1, 2,10) &
"&z=" & Rurl()
Could there be a similar approach to edit or view child record or in other words how do I see different forms when scrolling records depending on what the criteria is.