Yiannis

lol it seems that your paradigm doesn't work... Any other free cost solution? Yiannis

I dont beleive FM7 it is the first database tool that can not copy or duplicate a table!!! You must purchase some other tools with a cost between 100$-195$. Incredible...

Thanks Stephen but in my language Greek I dont have any problem with in the name of a field or in the data of a field even in the sorting. My proble in FMP6 was that I couldn't use web companion for instant publishing a layout in my language. Is this OK in the new version?

Is FMP 7 Multilingual? Because in the previous version 6 the web companion did not function properly when instant publishing a layout in a different language with non-Roman characters.

Thanks Garry Is this working properly and much better than a browser as the white paper from filemaker said ?

I have read a white paper from filemaker downloads site in the address : http://www.filemaker.com/downloads/pdf/fmp_vs_browser.pdf So I can not understand it completely and my question is: Can I working a FM database between 2 remote PC's with an internet connection without a browser? And what I need for this to happen? Also I wnat to know if can it be with up to 2 PC's? Is that working fine without a browser? Thanks in advanced...

I have read a white paper from filemaker downloads site in the address : http://www.filemaker.com/downloads/pdf/fmp_vs_browser.pdf So I can not understand it completely and my question is: Can I working a FM database between 2 remote PC's with an internet connection without a browser? And what I need for this to happen? Also I wnat to know if can it be with up to 2 PC's? Is that working fine without a browser? Thanks in advanced...

Please guys give me a url for downloading Claris Homepage 3.0 !!!

Ok but how many pages existing in the Google with "Download Claris Homepage" ?

Thanks guys but Iam insist to asking if someone knows any url for downloading Claris Homepage 3. For me is an issue of curiosity...

Please! Can anyone help me to find "Claris Homepage 3.0 for Win" for download it?

The "Go to Next Field" command can go from one repetition to another in the same field?

How can I set a global value rather a repetition number in a Set Field script? For example: Set Field["File2::Field1"-global value,"expression"] (this syntax is not valid) rather Set Field["File2::Field1"-3,"expression"]

Ok in list view, but my question was about parts in a layout can we make a part to be freeze? for example the header part of a layout to be freeze. Can be? Or for example I have two portals in a layout in the body part and I want to scroll down both of them together so I must use the window scroll bar and not the portals scroll up but I want the field labels of the portals to be freeze when Iam using the scroll bar. Can you suggest me a solution?

You mean guys that in a layout I can put more than one "Header" part? As I still know this is not possible. Can you explain me better what do you mean? Thanks for your support.

Can we freeze an object in a layout or a part of the screen in a layout like MS Excel? Or can you suggest me a solution? I need a left and a top part of the screen in a layout to be freeze when the horizontal and vertical scroll move the screen right and down.

I think that I have found the solution. Now from a line in the portal who belongs to each car, I can go to the related record in the reservation file and with a calculation index field "CarId & ReservationId" I have made a relationship and I can go to the specific reservation Id for this car. So I think with this method I can handle a multikey definition. I am a newbie in FM any other suggestion for handling those kind of solutions it is useful for us. I will try Ugo to translate in English language a part of my solution with this problem who we discussed and make it attachment to the forum. Thanks for your support!!!

Hi Ugo, I suppose that to make a view plan in FM for reservations its not so easy thing. I have search the web for an example solution with FM but I couldn't found anything. So the description of the solution is: I have plan the solution under a "rent a car" needs but the same needs belongs to a hotel/room reservations. 1. Car File 2. Reservations File 3. Reservations Temp File 4. CarPlan File In the carplan file I use 2 portals one with the cars to bring me all the cars from the related file with a relationship of a constant=1 for all the records in the car file. The second portal bring all the reservations for each car from the reservation temp file because the needing of the temp file creation was that in a line of the 2nd portal I must appear every reservation of each car and this happen with a relationship between plan and temp file bases in a constant=1 all the records in temp file have the same value in this constant. So it works like this: Portal-1 Portal-2 ........ 3/2/02..3/3/03..3/4/03 Car1.... Cust1...Cust1......... Car2.... Cust2...Cust3...Cust3. Car3.... ........Cust4...Cust4 The 2 portals are so close that this appear to the user as an array with x&y axis. I dont know I am I so clear? If I am not I can describe more details. Thanks for your interesting.

Ok Ugo I have read this article but I still not understanding how can I make what I'm need. Can you drive me to the steps of this structure?

I don't know if in this url in the same forum there is a light for me? http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB17&Number=47783&page=8&view=collapsed&sb=5&o=&fpart=1

The shape does not appear well. I think that you understand. Sorry!!!

Ok Ugo I will remind you my problem in the portals forum to give you another paradigm for what I need: "My problem is that I have a file with name "Room Reservations" and another file with name "Plan of rooms" with a related portal from a third file with name "tempfile". I use the temp file to hold all the reservations for a room using "RoomId" match field so the portal in the "Plan of rooms" can appear all the reservations for each room. The real problem is that because I have a relation between "Plan of rooms" and "Temp" files I can not use the portal fields.If I click them to go to a related record in the "Room Reservations" file. How can I make the portal to be related with both files?" So after the solution who Ugo gives me I can go from the portal line to correct Room. But imagine that in my portal plan a specific room have two reservations in the same line one at 3/2/03 and one at 3/4/03. When I click in the same portal line the field of 3/2/03 it is go to the correct record in the Reservation file but if I click in the same portal line the field of 3/4/03 it is go again to the first record in the Reservation file who can find, for this example the reservation of 3/2/03 and not 3/4/04. Because the relationship of the portal it is builded in the RoomId basis and not in the ReserveId basis. I need both... A liitle example shape of the plan: ........3/2/03..3/4/03..3/5/03 Room1....Cust1...........Cust2 Room2....Cust3...Cust3...Cust3 Room3............Cust4...Cust4

If a customer have 2 orders with the Show Only Related choice I shall go to the first relation record of 2 because it understand the relation between CustomerId's and not OrderId's. The problem is that I must go to the right order of the customer and for the moment with my previous described relations it doesn't know the right Order Id to go. I' not using a portal only a button.

I have a relation between two files for example: Realation:Cust2order = Customers --> Orders (CustId <-> Orders::CustId) I want from the customers file to go to a related record in orders file, but a customer have more than one orders. How can I use in the Cust2order relation field key definition and the Orders file match key (OrderId) together with (CustId)so the script command "Go to related record" to have a succesful execution?

Yes It working. It was so simple... Forgive me I just came from MS Access and Vba after a long period of masochism with those products and I can not find yet my rythm with the thinking of FM scripts.