Hello. My work has recently begun switching over their database systems to FMP9, and it's my job to get all the functionality running, but I'm new to FM and need some pointers. One of the things I'm struggling with is getting scripts to run at various points. For example (this is all in FMP9), say you have a list of parts, each of which has an ID number. On a related table, you enter the ID number, and it instantly enters the information about the parts into other relational Edit boxes. However, this uses references to the related database, and I would like the information received to be copied to this table, instead of just showing the reference to it. The data should then be changeable without altering the related database. Is there any way to do this from the moment the ID number is entered? Thanks.

It is possible to run a script triggered by data entry by using a FileMaker plugin such as zippScript.

However, that's not necessary here; you can do this with Lookups.