Link columns

Link columns are used to create relationships between data tables.  There are four types of link columns:

• • LINK - single reference to a row in another table, a select list is presented along with a link to go to the linked object

• • LINKSET - a non-ordered set of links, you can use the select list to add items to the list, click the X to remove from the list

• • LINKLIST - an ordered set of links, use the select list to add items to the list, up/down arrows allow re-ordering of the list, click the X to remove from the list

• • LINKMAP - an ordered set of named links, will show similar to the LINKLIST with addition input field to allow a name for each item. Item names must be unique

To change the contents of the select list for a table, see Pick Lists

All link relationships in the database are easily navigated in both directions.  This is the real power of PermeAgility.