christof

The client is bring run on Citrix, the FM Server app is being hosted on a dedicated server. Does that clarify? I have to admit, I'm not a network guy, I just use FM and I've been asked to work with the network guys to get this thing running. I can give you more details if you'd like.

Is is possible to have a portal display the records of another database without using a relationship? I have an office-wide contacts database that would be used to help populate project specific contact databases. Something like a layout for the office-wide list, and a layout for the project list, but with no real relationship between the two. Since we have consultants that we use on multiple projects, their records should appear in both places, as well as have some different info for that consultant for each project. Hope I'm making sense.

I'm setting up FMS on a Citrix server. I have things going along pretty well, excpet for this. One of the databases uses scripted buttons with sorts to display only the relelvant records to a user. On stand-alone, it works fine, but as a hosted file I get the following error: "The previous script step, "Sort", could not be completed becuase it restores an invalid request. Do you wish to continue with this script" I press continue and it seems to work fine. What gives? Any help is appreciated. Chris

Here's the short version of what we're doing here. We are setting up FM Server 5.5 on a dedicated server. The plan is to have a new blank database reside in a seperate folder on our network for each project we start. Each project database will then be filled in gradually with all the project data. It is likely that one or more people will want to open and work in the same database at the same time. Here's the questions: 1. Is there some way to avoid the whole "administrator" & "guest" thing that happens when two people try to open the same database file? I was under the impression that Server would 2. The database uses sorts to display only relevant records, in fact, the records are in a perpetually in a sorted state for user editing. When a second user tries to sort the data they get an error - something about the data not being available from previous sort?... I can get the exact wording if you need it. 3. Server Administrator Guide says that all databases that are being hosted shoud reside in the same directory as Server or one level down. This is not going to be feasible. I think we can use shortcuts instead, yes? Also, does this mean that every time we start a new project, I have to go and put shortcuts to the new databases in the Server folder? Thanks for any help you can offer. Chris

Does anyone know of a plug-in that will allow users filling out a timesheet to pick dates from a calendar? Ideally, there would be a "Week ended" field in which you could type out the date, or you could click on a button beside the field which would bring up a small calendar for the month and you could click on a date. That date would then be passed to the "Week ended" field. Thanks in advance. Chris

Hi all, I am in the process of setting up an installation of Server on a Citrix Metaframe box so that multiple users can access the centrally stored databases over a TCP/IP connection. I have heard that this can be done, but before I drop multiple thousands of dollars, I would like to know if anyone has had any poor experiences with this type of installation. Most users will be accessing with fairly fast connections. The Citrix box will not be a speed demon, but I'm not sure that is a problem. Any advice or cautions would be appreciated. Chris

Wow, Chuck you have a big brain. How would you go about modifying that operation so that a portal row is permanently hilighted once a condition is met, such as a radio button being selected or a value in a certain field being set? Can something similar be done in a list of records that display "List View" from the layout setup, as opposed to using a portal? I'm somewhat portal-shy.

I have a laout that has a body in it that I have stretched over 4 pages. In the body are 4 different fields, each with a text header (not a layout part header, just dumb text). I stretched the body out becuase some field contents in the body could potentially get quite long, so I wanted to give myself some room. The problem is, when I put in some lengthy test data into the text fields, the text line at the bottom of the page can get sliced in half and continued on the next page. Also, depending on the length of some of the fields, the text header can be orphaned at the bottom of the page and the field will just begin at the top of the next page. That's bad. So, how can I avoid slicing of text in a field that breaks across pages; and, is their some way of not letting feilds break across pages if that break will occur in the first couple lines? I know the second part is a long shot but I have to ask. Thanks in advance. Chris

quote: Originally posted by PinnWal: FirstName & " " & LastName Oh yeah, that's right! Thanks man.

I used to know how to do this but I've forgotten... I need a field that has a calculation in it that will take a first name and last name field values and combine them (with a space in between) to form a "full" name result. Pretty easy, no? Any help would be appreciated. Chris

Help. My scripting is a little rusty. I have a text field that is only inhabited by 5-digit numbers. I want to write a script that looks at the first 2 characters in the field and fills in another field based on what they are. I thought I could use the "Left" Text function to return the first 2 characters in the number string. Doesn't seem to work though. Anyone suggest a method for doing this? I can post the body of the script thus far if you want to see the exact functions or syntax. Thanks in advance. Chris

Help! I have been puttering along on a little database that I use personally to track my work experience (in hours) as it relates to my professional registraion. As far as I know I am the only person to create a database for this particular process, but there are over 2000 other people like me that all track the same experience. I showed my database to a guy who really liked it, and he told a friend, and he told a friend... All of a sudden, there is an interest from the registration board in putting my database on the web so that all 2000+ interns across the country can record their work experience online. I've never used FMP to post databases to the web, and certainly never had to develop databases for use by so many people. So, I have no idea where to start. Can I get some advice from people who have done similar things on where to start? I need to know about what additional software I will require to manage and host this thing. The project is basically broken down like this: -user logs in to web site -web site accesses the database assigned to that user and displays it for editing. -each user uses the same database layouts but has their own unique records assigned to them. These records are not accessible to anyone else. -if a chnage is required in the standard layouts (e.g.: adding additinal fields), all the individual users' databases are updated accordingly. I am unsure if this means that there will be 2000+ databases (complete .fm5 files) that are served up on demand, or if there is one master database that has it's fields "populated" by the records of whomever logs in. Any advice will be greatly appreciated. Any books I should read on this? Chris