i see where i can create/change the easy ones...
how/where do i get information to access the properties of a lookup field rule?
i want to require that "field1" exist in table 2 and then use table2 to put a value into "field2".
i've got this so far:
+++++++++++++++++
dim tbl as P
dim fr as P
tbl = table.open("TrashPmt")
fr = tbl.rules_get()
? fr
V Change_Begin() 'Begin changes to the field rules.
V Change_End([L Commit]) 'End changes to the field rules.
Field_Rule_Get as P(fieldName as c[,variableFrame as p]) 'Get (or add) a rule for a field - includes variables of calc fields.
+PMTAMT.
+TIXNUM.
'+++++++++++++++++++++++++++++++++++++++++++++++++
Field_Rule_Get as P(fieldName as c[,variableFrame as p]) 'Get (or add) a rule for a field - includes variables of calc fields.
'+++++++++++++++++++++++++++++++++++++++++++++++++
?fr.field_rule_get("TixNum")
+Cross_File.
+Lookup.
+Required.
+Unique.
+Validation.
'+++++++++++++++++++++++++++++++++++++++++++++++++
?fr.tixnum.lookup.Type
?fr.tixnum.lookup.class()
= "Rule.Lookup"
?fr.tixnum.Unique.class()
= "Rule.Unique"
?fr.tixnum.Cross_File.Type
= "None"
?fr.tixnum.Validation.List.class()
= "Rule.Validation.List"
'+++++++++++++++++++++++++++++++++++++++++++++++++
i think the appropriate question is:
how do i get access to the "Rule.Lookup" class?
how/where do i get information to access the properties of a lookup field rule?
i want to require that "field1" exist in table 2 and then use table2 to put a value into "field2".
i've got this so far:
+++++++++++++++++
dim tbl as P
dim fr as P
tbl = table.open("TrashPmt")
fr = tbl.rules_get()
? fr
V Change_Begin() 'Begin changes to the field rules.
V Change_End([L Commit]) 'End changes to the field rules.
Field_Rule_Get as P(fieldName as c[,variableFrame as p]) 'Get (or add) a rule for a field - includes variables of calc fields.
+PMTAMT.
+TIXNUM.
'+++++++++++++++++++++++++++++++++++++++++++++++++
Field_Rule_Get as P(fieldName as c[,variableFrame as p]) 'Get (or add) a rule for a field - includes variables of calc fields.
'+++++++++++++++++++++++++++++++++++++++++++++++++
?fr.field_rule_get("TixNum")
+Cross_File.
+Lookup.
+Required.
+Unique.
+Validation.
'+++++++++++++++++++++++++++++++++++++++++++++++++
?fr.tixnum.lookup.Type
?fr.tixnum.lookup.class()
= "Rule.Lookup"
?fr.tixnum.Unique.class()
= "Rule.Unique"
?fr.tixnum.Cross_File.Type
= "None"
?fr.tixnum.Validation.List.class()
= "Rule.Validation.List"
'+++++++++++++++++++++++++++++++++++++++++++++++++
i think the appropriate question is:
how do i get access to the "Rule.Lookup" class?
Comment