I have a data entry screen for entering expenses.

Is there a way of filling in subsequent fields depending on the first entry? The first entry is into a free text field (although it's supplemented by a drop down menu as many entries are the same.)

I want something that looks to see whether an entry has been made before and matches the other fields if it finds it. If it doesn't then it shouldn't fill it.

Linked to this, is there a way of running a script upon exiting a field? I know how to run one upon entering the field but can't work out how to do it upon exit.

Thanks

John

You can try http://www.monkeybreadsoftware.de/filemaker/

Their plugin allows you to run a script on entering or exiting a field.

I have a similar problem in my database and I use a "new Record" script. I have a popup window where the user can enter data in the "first field" then I script the creation of the rest of the record.

Read about Lookups.

Start with this Help Information.

Link

Lee