Hi all,

I'm still working with 5.0 and am making an orderdatabase for a client of mine - the ordernumber is a unique auto-entered value.

But what they also want is a unique invoice-number which has to be made when you click on a field in the order-record, and is not generated with a new record at the same time as the ordernumber.

I wanted to use a seperate invoice-database for that and use a portal in the orderdatabase, but I don't seem to be able to use that invoice-field as a button to make a new record in the invoice-database?

Can anyone help me out?

Not sure if this answers your question but you can define a field as a button. Just click the field then go to Format > Button, and select the script you want to run.

Does that help?

No Jasonwood

Thanx, but I'm afraid I already have the button, my problem is that when you make a new record - the ordernumber is incremented, but the invoicenumber is incremented as well!

I only want to increment that invoicenumber on the click of a button, and then add that invoicenumber to the order-record from which I clicked the button. I hope you understand what I mean...