mbungurz Posted April 21, 2009 Share Posted April 21, 2009 hi... i'm really newbie here... just installed software last night..hehe here's the problem: i've record with automatic counter number type (as Primary key) when i create new record the counter work just fine, but the problem is when i delete the record i've just created the counter won't start with the record number i delete example : 1...2....3.... and i delete record number 2 and create new one 1....3...4... how suppose to create with record number 2 so it will be like this.. 1...2...3.... sorry 'bout my very poor English.... thanks b4 ...GBU... Quote Link to comment Share on other sites More sharing options...
rodney777 Posted April 21, 2009 Share Posted April 21, 2009 Yes, this is how FileMaker works. The Automated Serial No will increment ir-regard of whether the previous record has been deleted. I ran a FileMaker Development business based in Singapore. Do email or give us a tinkle if required. Cheers. Rgds Rodney Blue Bay Interactive Pte Ltd +65-96834777 Email: filemaker@ymail.com Quote Link to comment Share on other sites More sharing options...
aaa Posted April 21, 2009 Share Posted April 21, 2009 Hi, mbungurz. If you use this field in relationsips is not recommend to change it. If not you can use function Get(recordnumber) Quote Link to comment Share on other sites More sharing options...
brucewilson Posted April 21, 2009 Share Posted April 21, 2009 Another issue is, what happens when you delete a record that is NOT the last one. bbb Quote Link to comment Share on other sites More sharing options...
mbungurz Posted April 21, 2009 Author Share Posted April 21, 2009 Hi, mbungurz.If you use this field in relationsips is not recommend to change it. If not you can use function Get(recordnumber) ahhh..... thanx aaa i'll try it...smiley-laughing GBU Quote Link to comment Share on other sites More sharing options...
mbungurz Posted April 21, 2009 Author Share Posted April 21, 2009 i still can't make it.... anyone can u help me with the script please...smiley-cry Quote Link to comment Share on other sites More sharing options...
mbungurz Posted April 21, 2009 Author Share Posted April 21, 2009 i still can't make it.... anyone can u help me with the script please...smiley-cry i mean how to checking the record number?? i hope someone know what i mean... smiley-cry help...please... thnx before.... GBU ALL... Quote Link to comment Share on other sites More sharing options...
aaa Posted April 22, 2009 Share Posted April 22, 2009 Hello, mbungurz ! Create one calculation field let say Rec_Num=Get(Recordnumber). And put this field at begin in layout row. Other way is symbol @@ in begin of row. I can attach example, but you can not look it because you is guest member. Quote Link to comment Share on other sites More sharing options...
mbungurz Posted April 22, 2009 Author Share Posted April 22, 2009 Hello, mbungurz !Create one calculation field let say Rec_Num=Get(Recordnumber). And put this field at begin in layout row. Other way is symbol @@ in begin of row. I can attach example, but you can not look it because you is guest member. an example would be a great2 help.... may be u can sent it on my email?? in mean time i'll searching in this forum... here's my e-mail, ydhprabowo@yahoo.com btw thnx for your help Quote Link to comment Share on other sites More sharing options...
mbungurz Posted April 23, 2009 Author Share Posted April 23, 2009 oohhh i seeee now... to use get(recordnumber) all night i figured how to use this thing... heheehhe.... 1. manage database 2. go to field you want to set autonumber 3.use calculated value then specify 4. use SerialIncrement("Text", Get(recordNumber)) am i right??? haha... it takes all night... to figure it out... Quote Link to comment Share on other sites More sharing options...
mbungurz Posted April 23, 2009 Author Share Posted April 23, 2009 and... here's new problem.... how to take field value and give it to Label on another layout (do Label must have a name first??) Example... field [Hotel Name] in HotelDataLayout======>>> into Label in DetailRoomLayout is there any properties to Label??? where i can put [Hotel Name] value into Label on another Layout give me clue please... Quote Link to comment Share on other sites More sharing options...
aaa Posted April 24, 2009 Share Posted April 24, 2009 Hi, mbungurz . Can you send me the little example of your goal? I will do it in your example. andranik@kotayk.am Quote Link to comment Share on other sites More sharing options...
mbungurz Posted April 25, 2009 Author Share Posted April 25, 2009 ok... i already send the file... thank you so much for your help Quote Link to comment Share on other sites More sharing options...
mbungurz Posted April 25, 2009 Author Share Posted April 25, 2009 ok... i already send the file... thank you so much for your help Quote Link to comment Share on other sites More sharing options...
mbungurz Posted April 28, 2009 Author Share Posted April 28, 2009 aaa.... have you recieved my files...?? Quote Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.