The Original FileMaker Community
Business Templates - Demo Apps - Video Tutorials -Samples - Help - 46000 Member Forum

The Leading Filemaker Developer Tools

FileMaker And Auto Enter Lookups – FileMaker Today


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.


Here you can see the field auto enter dialog box.


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.


=

More info about the author and FileMaker in general, contact me at This email address is being protected from spambots. You need JavaScript enabled to view it..

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More

Privacy & Cookies Policy