Over 46,000+ Business Solution Developers Find answers, ask questions, and connect with our community of business solutions developers, business owners and partners.
A very popular auto enter option is called the lookup. This auto enter option does not enter information into a field when a record is created. It is dependent upon refreshing a valid relationship between two or more tables and when that happens, the lookup feature will copy the information from a child table into a field in the parent table. The copying of information is triggered when the parent key field in a relationship had data first entered into it or data is edited.
In a little more detail, a lookup can take place in at least five different situations.
1) When data is first entered into a parent field of a relationship, the lookup is executed for that record.
2) When data is edited in a parent field of a relationship, the lookup is executed for that record.
3) When the replace command is executed within a parent key field of a relationship, the lookup is executed for all the records in the found set.
4) When data is imported in from another file into a parent field of a relationship, the lookup is executed for that record ( note … this can be turned off via one of the import dialog boxes).
5) There is also a relookup command under the File menu and as a ScriptMaker step. When the relookup command is executed for a parent key field of a relationship, the lookup is executed for that record.