Ahmet

Thanks, dont have developer but Brian dunning's worked great....

Hi everybody, I have a problem: I need to convert a number into text like: 234.678.000 and I need twohundredthityfourmillionsixhundredseventyeight. Is there a way to do that.. if so please help me. (I searched the forum but had no success)

Sorry you're right, I will try and search.

Thanks jeffer, interesting that there's only one reply....

I have a Db for work-orders and have a field for serial numbers that goes IE2345, IE2346 and so on. It is a number field, Indexed, with Autu enter serial, not modyable auto, strict, required value and unique. If mistakenly I change the "next value" field in options to a lower value than the next in line it gives me a double serial number.. Is taht normal? How can I avoid this.... Thanks a lot in advance....

Thank you people, Your answers along with the thread referenced by Anatoli helped me to see quite a bit clearer. ACT

Thanks Anatoli for the prompt response, Well then: 1-What dou you mean by transaction posting system. How do I implement it. 2-What do you mean by changes in FM 7 3- The pictures are on each users hard drive. I t is quite difficult for the users to upload images to the server, open the file and attach the link. Is there a waty to automate this task. EG open picture, resize to a certain size (Not TN size) save it to a predefined folder on the server with a name calculated by FM (of course unique) 4-I m trying my best on planning ahead. But when you say do not calculate across records: Do you mean any calculation or just summaries or complex calculations. EG if I have a name and last name field with an employee number that links"orders" and "employees" and ı want the emplyee name to appear in one field and calculate therefore. Is this already something to be avoided or do you mean complex calcs. Kind regards.

Hi Everybody, I am quite new to filemaker but as the package is so easy to learn, already in the process of building a 30 file multiuser database. As I have no previous experience with Filemaker, especially not with such a big DB ı want to avoid pitfalls. I am considering to run FM Server. Havent bought one yet but have already researched in the Web. Q1: 3 possibilities: 1-Buy from FM İnc. (999.-US$) 2-Buy from companies likea Atomic park...(869.-US$) 3-Buy from CDW or Cos central (FM server 5.5 VLA)(699.-US$) I have no Idea what VLA means, and what is the benefit if I buy from FM direct. Q2: When I have calculations in fields, calculation fields and scripts...where are they processed in the server or the users machine. What do I have to take care of. (BTW I will be running PC's). E.g. if I have an inventory of goods and I am controlling the stock by a summary field, will tis cause a problem when I have 4000-5000 records...The users might run P-133 machines. Q3: When I am inserting pictures into fields, this increases file size, lets assume that ı have no probs regarding space, will it slow down my system when ı have a 20GB file with 6000+ records. Q4: What are practices that should be avoided in order to maximize performance (or better in order to perform normally without leaks) I think thats enough.... I have other questions boggling my mind but I better put them in the appropriate forums..... Thanks a lot in advance for maybe saving me lots of corrections.....

I had same problem but solved it by setting printer resoılution for graphics higher. Tell me if it worked...

@ Ken I guess it goes a bit faster: Either create the button rotated and then make the BG transparent after 1st rotation in layout mode or... If you did not create the graphic yourself and dont have Editing software for the picture.... After rotating, cut picture and paste special as Bitmap. rotate three more times and make BG transparent. Should work...

Is it possible to select the whole contents of a field in a value list, if the text was entered in multiple lines by using Carriage Return (Enter)