Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Indonesian User need help with record problem


mbungurz
 Share

Recommended Posts

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...

Link to comment
Share on other sites

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: [email protected]

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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...

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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,

 

[email protected]

 

btw thnx for your help

Link to comment
Share on other sites

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...

Link to comment
Share on other sites

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...

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use