Hi all,

I have been creating a Membership Database.

I have members with existing numbers - starting at Number 1.

Any new members, I wish to start off at 80000.

However, what is happening is:

I add a new member - it gives the correct new number of 80000 onwards, but when I amend details (such as an address) on an existing member the database then gives this amended record the new 80000 + number instead of keeping its original one.

Could anyone please have a look at the attached file, and suggest where I'm going wrong.

(I have uploaded the file to my server - the URL below is a direct link to download).

http://www.box.net/public/static/4xtyj0bens.zip

It would be much appreciated.

Many thanks,

Shane :-)

just a quick look reveals that Membership ID has BOTH a serial number and some calculated value associated with it.

Perhaps this should be 2 fields?

Hi

check only:

1) serial number

2) proibit modification

( that calculated value isn't needed )

Hi Keith, Hi Ray,

Many thanks for your replies.

I have amended the database so that only the following is/are checked:

1) Serial Number - Generate on Creation. Next entry 80000 increment by 1

2) Proibit modification of value during data entry.

In Options/Comments - it now shows 'Indexed, Auto-Serial, Can't modify auto'

However, when I amend an existing Member it's still changing the Membership Number to 8xxxxx

Any more advice..?

Many thanks,

Shane :-)

Hi Shane

It's impossible...or so it seems to me !

1) How do you amend an existing member ?

2) Have you the v3 of FileMaker 7 ?

does your field definition look something like this - calculation turned off?

membership.pdf

Hi Ray, Hi Keith,

Again, many thanks for your replies. I appreciate the help.

Keith - Yep, that's how it looks like. Exactly the same.

Ray - to amend the member's details, I just click on 'Amend Details'. Change anything that needs doing, then select 'Submit'.

The reason for this is so a 'snapshot' of the details is created, and the user can then scroll down to see that the details previously were.

I'm at home at the moment, so can't check what version of FileMaker 7 we have at the office.

I do have a trial of Version 8.5 here at home that I can open the database with.

If this problem can't be resolved - Can you suggest another way of performing the task I require - even if it means changing how the database is designed.

Many thanks,

Shane :-)

Ahh...

That script makes a new record, so it gives him a new Serial Number !

I think that you have to change the script:

"isolate portal row and duplicate"

Hi Ray,

I initially had help creating the scripts - any idea how I would perform your suggestion..?

Many thanks,

Shane :-)