shaneferguson Posted September 19, 2006 Share Posted September 19, 2006 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 More sharing options...
Keith LaMarre Posted September 19, 2006 Share Posted September 19, 2006 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? Link to comment Share on other sites More sharing options...
Raybaudi Posted September 19, 2006 Share Posted September 19, 2006 Hi check only: 1) serial number 2) proibit modification ( that calculated value isn't needed ) Link to comment Share on other sites More sharing options...
shaneferguson Posted September 19, 2006 Author Share Posted September 19, 2006 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 More sharing options...
Raybaudi Posted September 19, 2006 Share Posted September 19, 2006 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 ? Link to comment Share on other sites More sharing options...
Keith LaMarre Posted September 19, 2006 Share Posted September 19, 2006 does your field definition look something like this - calculation turned off? membership.pdf Link to comment Share on other sites More sharing options...
shaneferguson Posted September 19, 2006 Author Share Posted September 19, 2006 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 More sharing options...
Raybaudi Posted September 19, 2006 Share Posted September 19, 2006 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" Link to comment Share on other sites More sharing options...
shaneferguson Posted September 19, 2006 Author Share Posted September 19, 2006 Hi Ray, I initially had help creating the scripts - any idea how I would perform your suggestion..? Many thanks, Shane :-) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6563 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 accountSign in
Already have an account? Sign in here.
Sign In Now