Crossreferences

back to main page - contents - top
previous topic: Importer definitions
next topic: Actions
Cross references link the table together such that values of a field in one table can only possibly be derived from the values of a field in another table. Example: Plates can be assigned to projects, that is the project number of a plate directly refers via a cross reference to the numerical ID of a project. Cross references are used to update objects when a related crossreferenced field in another field has been changed or when values of fields shall be validated.

view cross references

Fields in the cross references table

KeyDatabase fieldHeaderDescription
NUMIDNUMIDNUMIDThe numerical id. 
IDIDIDThe short name of the cross-reference. 
DatDATLast updateThe date on which the cross reference was last changed. 
OwnerOWNEROwnerThe owner of the crossreference entry (admin). 
TableTBLTableThe table which the cross-reference refers to. 
ConditionCONDConditionA condition suitable for inclusion in a SQL query. <*ObjectID*> is a placeholder for the ID of the current object which contains the crossreference. Instead of ID any other field of the current object can be used, correspondingly. <*all_shared_with_object_owner*> instructs the program to only look for objects, which are shared with the owner of the current object. 
FieldFLDFieldThe field to which this crossreference is referring to. 
DescriptionDESCRIPTIONDescriptionThe field in the referenced table, which contains the description of the referenced field. 
IncludeEmptyOptionINCLUDEEMPTYOPTIONInclude empty optionA flag telling whether the empty option shall be included in the options constructed by the cross reference. 
OrderByORDERBYOrder byThe field of the referenced table by which the options shall be ordered. 
ShareSHARESharesThe Share field is used to give other users viewing or modifying rights for a certain object. Permissions can be given to specific users, to the group to which the object owner belongs to and to all users. 

Actions in the cross references table

IconDescription
display (and edit) the cross reference
create a new cross reference
copy the current cross reference
view cross references
delete the cross reference
update the cross reference


Contact the system developer - back - reload