Hi!

I have an invoice page where I have set it up so that once I put the client's name in, it automatically takes the address from a relational contacts Database. Is there any way to set it up so that if the client is new (so no address ifo to be found), I can enter it into the invoice and have it automatically make a new record in the Contacts DB? (since the address fields are from a related DB, I can't enter information into them, right?

Currently, I have a button that does nothing more than open the Contacts DB - can I even script it into that related DB so it at least goes to "New Record" ?

Thanks, sarah

Unfortunately FMP does not offer a way to trigger a script when a user tabs out of a field (or from a calculation field for that matter), the user must interact by pressing a button or selecting the script from the Script menu. There is a 3rd party, free, plug-in that apparently allows you to trigger scripts when tabbing out of a field but I have not tried it to confirm, nor can I remember the name.

""can I even script it into that related DB so it at least goes to "New Record" ?"

Create a script in the Contacts DB with the script step New Record/Request. Then have the button in the Invoice DB run the New Record/Request script in the Contacts DB.