Jump to content

Membership Number errors.


This topic is 6457 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 :-)

Link to comment
Share on other sites

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 :-)

Link to comment
Share on other sites

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 :-)

Link to comment
Share on other sites

This topic is 6457 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.