newbie in need of formula for PO number

[auguzt]

Hello..... I'm new to filemaker pro. Using it for about 2 weeks now.

just upgraded to FMP 5.5.

I need to auto-serial a PO number Field. The Field have to look like

XX##/YY/ZZ where

XX = Cust Ref (Related by Custmer Name in Contacts File)

## = Year in 01,02,03 format

YY = Supplier Ref (Related by Supplier Name in Contacts File)

ZZ = Auto generated no. (+1)

I can actually do this using 4 different fields instead of 1.

But I believe there is a calca or Formula of some sort to achieve the same result.

Pls Help me

Thank you very Much

[pspafford]

Hey auguzt.

1. If you haven't already, create a date field called CreationDate. Select it in Define Fields, then click the Options button. On the Auto-Enter tab, check "the", then select Creation Date from the drop-down box beside it.

2. Create a text field called RecordSerialNumber. In Auto-Enter, check "Serial number". In the "next value" box change the "1" to "10001" (a personal preference; now all of your serial numbers will have the same number of digits.

3. Create a calculation field call PONumber. Make sure that the "Calculation result is" box says "Text". Use this formula:

ContactsByCustmerName::Cust ref & Right( Year(CreationDate), 2) & "/" & ContactsBySupplierName::Supplier ref & "/" & RecordSerialNumber

(I took the liberty of naming your relationships)

4. The result should look like: CR01/SR/10001

That oughtta do 'er.

Post again if I haven't understood what you need.

Paul

[auguzt]

Thank you very much pspafford.