Solution for Job Number - Best Practice Please?

[cka]

I have a Clients Table + a Jobs Table.

I have a Relationship of Jobs to Jobs where (IDclient and the Year Job was created Match)

Because I want to create a unique job number that identifies the year it was created + order in which is was requested by the client.

I have set a portal in the Jobs Layout to

display Jobs related by id +year.

Sorted in descending order.

This portal is displaying a unique job number utilizing...

The last 2 year digits (date_year)

The client code (client_code)

and the portal row number via Case( Clients::IDClient; Get( RecordNumber))

ex.

11-ME001

11-ME002

11-ME003

The example above is my job number, which displays correctly in the portal.

How do I get that number to display on the individual Job Layout?

I hope I was clear. I need to get back into database and filemaker lingo.

Thanks.

[comment]

I want to create a unique job number that identifies the year it was created + order in which is was requested by the client.

Filemaker makes it very difficult to create such numbering reliably. See:

http://fmforums.com/...655#entry347655

I'm afraid I didn't understand the rest of your post.

[cka]

Thanks. I understand the rationale in the link.

Totally makes sense...

But I still would like to utilized this naming convention.

Jobs created in filemaker are associated with files on the harddrive.

Using a numbering system like is more efficient for the finding of files.

So are there no real options?

[comment]

Jobs created in filemaker are associated with files on the harddrive.

And how will you generate the names of those files?

[cka]

Well in my dream world it world a script would create the initial folder and all the subfolders.

But right now it's just manually.

[comment]

It doesn't have to be a dream - see, for example:

http://fmforums.com/forum/topic/79232-using-applescript-in-fm-pro-10-on-mac-os-x-to-create-a-folder

And if you create the folder/s after creating the record in Filemaker, you can use ANY unique identifier to link between the two. You can also have Filemaker open the related folder, using either AppleScript or Open URL{} script step.

[cka]

Thanks for the link! A bit over my head, but who knows. I may give it a shot!