pmusaev

Currently our organization uses Windows 2000 Terminal Server to host our Filemaker databases. The HUGE drawback we face with this setup is the multi-user capabilities that [seem to] lack. All the files we require to be multi-user are setup as multi-user and anyone working within the LAN can open multi-user files. Remote users can open files, but once they have a file open, it is not accessible by anyone else, until the remote user closes the file. This is causing us big problems and we are looking at our options in removing this holdback. I would appreciate some feedback as to how others are using Terminal Server and FM Server 5.5 and if a solution is even in existence to negate this problem I am faced with. Thank you all in advance.

any luck with figuring this out? I am interested in the solution... please post

I am using Version 5.5 and would like to know as well...

On another note... I have a field who's values are the records of another database and am seeing that records with the same values are not being shown, yet I need them to be shown because there is a date value associated with that record that is different and important. How do I have the relationship show duplicate records?

What is the best way to create a relationship that allows for values from one file to be displayed in another file. I don't want them to be associated with an ID or anything. For example, I need to define a relationship where I can create a drop down list that is generated from field values from another file and in order to make it useful to me, I would like another field to be automatically filled in depending on what was chosen from the drop down and this is where I need a Relationship. I just define two of any fields and it seems to work but I am not sure if this is best practice. Hope this makes sense. Thank you.

Ok, converted the number with a mathematical equation... but it relies on the database to always be sorted by a certain field. Not a big problem, I've just included the sort in every function in the database. Any better ways to do this?

"Fraction of Total Of" Summary field seems to do something relevant, now I just have to convert the number it gives me into some sense...

Exactly like using the Find function on a specific date... except I need this to be done for all dates entered within the timesheet.

Please, I have a field that I would like to contain the count of a specific value in a specific field. IE > I have a timesheet file and I would like to count the number of timesheets there are for "Jan 2, 2004" or how many timesheets there are for "Dec 3, 2003" etc... does this make sense? cheers all!

What are people doing to save historical information about Found Record Sets? Every week I hand out a list of records based on a found set and would like to reference these records later down the road. Any ideas you may have to share would be greatly appreciated. Cheers!

in addition... Things I don't want are... 1) 2 Fields per Cost Code (one for ST and another for OT) 2) 2 Fields for Cost Code Totals (one for ST and another for OT) 3) Script that requires "hard" copy of Cost Code entered.

Hoping to gather some insight on how to improve my relationship... I have 2 files (1 - Timesheet , 2 - Cost Codes). *Please see attached documents* I am experiencing an extreme slow down when I run my script "Calculate Totals and Go To Summary"... can anyone provide me with a more efficient way to do what I am trying to do? As well, adding codes is a little bit painful. Thanks much in advance! Cost Codes.zip

I would like to upgrade my companies system of forms and tools to help the managers increase their productivity. I was hoping I could gather a sizeable collection of "Tips&Tricks" and things to look out for and things to consider from the community here at FMForums.com ... The system is a collection of forms to use for historical purposes, Drawings Transmittals, Fax Cover Sheets, etc... and right now I am planning something of the following: Create a central database holding contact information and have the remaining information fill in itself automatically when the company name is identified (say in the Fax Cover Sheet, all you have to type is the company name). I would like to incorporate the function where if you type say "Ch" there will be a list of items for you to pick from (to avoid having to type the exact spelling). Download the Dynamic Menu plugin and create a custom menu bar. Prevent un-authorized access to layout view and defining fields. Create one file as the "Menu" and have it always available on the screen for one click access to all files of the system. These are my initial (general) thoughts, if you have a free moment... would you mind advising me in ways that I need to be advised and just offering your professional opinions. Thank you all in advance.

When I try open a Filemaker file of mine... I get the following message: "Is write protected or in use - you will not be able to make changes." but it doesn't even come up. Please help, I really hope my data is not lost. FileMaker Version: 5 Platform: Windows XP

I am not sure if this is the right forum to be posting into, so please re-direct me if need be... I am creating a set of multiple databases as a custom solution for my company. I was hoping you could all share any tips and tricks you've found useful as your databases have grown in size (things you wish you had known or done earlier), thanks in advance to everyone that shares. Cheers! Version: v5.x Platform: Windows 2000

Steve, Not to be ignorant... but how do you mean "restore" the toolbars when you switch to the default FM menu bar. I am not familiar with the plug in (too much) and thank you for pointing out the limitations (this is very helpful!) Cheers! Version: v5.x Platform: Windows XP

Can I get some recommendations as per what plugins are out there for menu creation (or control) I would like to create a custom business solution. creative and functional menu system is what i'm looking for. thank you in advance. Version: v5.x Platform: Windows XP

what are the commands to create BOLD text in a script... say if i set field to "Joe Blow, AsCE" and wan't the "AsCE" to appear bold and italic. Version: v5.x Platform: Windows XP

sanks Queue!

what function would i use to test if a given text string appears in a text field. ie. say i have a field that holds the value "THIS STRING IS TO BE TESTED" and I have a function that calls... If FIELDNAME CONTAINTS "STRING" RETURN POSITIVE. any help would be appreciated. cheers!

Almost... because the cost code dBase needs to make a calculation from the main dBase and then the main dBase can gather that calculated information from the portal... make sense?

what are some ways that people are "freezing" records so that once a user has created one (record) they can hit a button and "freeze" that record so it is non-modifiable in the future. cheers!

*NOTE* I HAVE NOW INCLUDED A FEW FILES FOR EXAMPLE - please help! i have a database where each record is a specific cost code and i use these records to fill a value list in my main file. also in my main file, is a summary log where i would like to print out every cost code as well as a calculation. the calculation i need to calculate is the following: "the total amount of hours spent on each cost code in all (found) records" i am able to do this with a simple Case statement that checks the "cost_codeX" fields, the only problem i have is relating these fields to the actual cost codes in the other file, i tried using a portal but i did not accomplish this. also, i have no field on which i can relate the cost code database to my main file... unless i create a global id in my main file and also create this same field in the cost code dBase and set them both to 1. any help would be greatly appreciated, cheers! Cost Codes.zip

anyone point me to more info about using this "clairvoyant" filter please?

yes i have, thank you Lee... i am currently using a Popup list but i am trying to get around the headache of having a HUGE popup list... thought this would help. gonna look at your examples right now, cheers!