Add Letters to front of Numbers! Auto Complete!

[bigfatgreedykat]

Hello All

I have an invoice table, payment table and orders table. All are related.

If i create a new invoice it is automatically numbered i.e 192.

I have payments table and orders table in the same page.

I would like the payments table to automatically numbered as well but with P added to front i.e P192

Same for Orders i.e O192

Any ideas?

Look forward to any replies.

regards

BFGK

[Vaughan]

Are you using auto-entered serial numbers? If so, Put a "P" or "O" in front of the next serial number. in the Define (Manage) Fields dialog.

[bigfatgreedykat]

In Layout mode i have dragged other fields on Invoice table.

INVOICEID is serial and this updates automatically. I need to update the other tables automatically when i create a new record?

So when INVOICEID is created it automatically creates PAYMENTID and ORDERID.