littleitaly5588 Posted March 1, 2004 Share Posted March 1, 2004 Hi, I have a number field named AddendumNum. I want to build a calculation field named MultiAddendum that will copy the AddendumNum and add a suffix with numbers in a series for each new record with that AddendumNum. Example: AddendumNum 04-03b 04-03b 04-03b MultiAddendum 04-03b1 -- record 1 04-03b2 -- record 2 04-03b3 -- record 3 Thanks in advance! Adele Link to comment Share on other sites More sharing options...
Mike D. Posted March 3, 2004 Share Posted March 3, 2004 Adele, You need to first create a self relationship based on AddendumNum. Next create a number field called something like MultiNum. Then create/add to your script that creates new records that would include the following step Set Field[MultiNum, Max (Self_AddendumNum::MultiNum) + 1] Then have a calculation field MultiAddendum = AddendumNum&MultiNum. HTH, Mike Link to comment Share on other sites More sharing options...
littleitaly5588 Posted March 9, 2004 Author Share Posted March 9, 2004 Mike, Thanks for the reply! This looks like it will work. You were the only reply I received. I appreciate it! Adele Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7346 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