mad_mickey

Yes I am aware of the scenario with separate database files but this is all in the same file and same table as well! Thanks anayway.

I'm stumped at present with the following issue. I have setup a script to add comments to a worklog field adding a timestamp and account name prior to each entry. I have created a secure worklog field that standard users have no access to and made this field 'not modifiable' by standard users. To enable standard users to add comments to this worklog I have created a secondary worklog entry field which combined with a script enters the aforementioned timestamp and account information and then copies and pastes the worklog entry field into the worklog. This script has been setup with 'run with full access privileges' checked yet still does not allow modification of the 'worklog field by standard users until I give them full access to the worklog field which defies the point of the exercise! I am running Filemaker Pro 9.0.3 and Server 9.0.3 with OS X 10.5.2 Leopard on both. Any help would be greatly appreciated!

Thanks 'Breezer' you are a star!

I have a support database hosted on our filemaker server (8.0.3) which has container fields for adding file or picture attachments. Under my administrator 'full access' account I can add and export field contents of these container fields. My restricted access 'Users' group cannot access these fields. When they right click they do not even get the menu of options?! The access privileges for the 'Users' group is set to modifiable for these fields. Is there anything else I'm missing? Thanks for your help

Aaah, we're back online now. Spent half an hour writing an in-depth response this morning only to lose it all as the site was being backed up when I clicked send!!! Anyway, thanks for your help so far and to cut that long email short I currently have 2 options. 1) I have already imported the external forms database into a second table on the entry/main database and explored that option. 2) I have another database process that was setup in the same way and I print the forms in the following way: A script asks you which order you wish to collect information from (i.e. collects all the lines of the respective order) and presents that information on the required form. I prefer the second as it only requires one table and therefore simplifies the process as I have other external databases that have to be added (as tables) shortly with contacts, product information, etc. My only issue is that any information pertaining to that order realistically needs to be duplicated accross all lines in that order. This creates another problem of copying and pasting data from numerous fields across multiple records/lines of an order. Thanks for your help

I have taken over the task of rebuilding some sloppily put together databases and need some help with the re-structure. We have one process in our business for setting up a sales order and then printing off a confirmation, delivery and invoice notes. My predecessor has setup this process as 2 databases the first being that of a data entry database. The major problem with this database is that each line of an order is a new record in the database rather than each record being a new order which I think is the way it should be. The second database is a forms database which is related to the data entry database by an order number. We then have a rather clunky and long winded process of pressing buttons in both databases to copy the order number accross to forms database which then views all the related lines of that order in a form using portals? The reason I'm told this was done was to ease the printing of forms??! It has certainly not done this as we have one invoice that has 10 layouts allowing for the printing of different sized orders with portals covering 1 through to ten layouts!!! I would greatly appreciate some ideas as to how to structure this seemingly simple process and also maybe a transition process for moving the one order multiple record scenario to one record with repeating fields. Thanks for your help in advance.

I have had exactly the same issue. I'm using Leopard (10.5.1) and Filemaker Pro Advanced 9.0.3. Occasionally, my send mail script runs and then the email doesn't appear in Mail. The only difference I have is that the message usually appears in my drafts mailbox a few hours later or the next day. When it doesn't work I usually run the mail script again and it's fine. You're not using 'Spaces' in OS X are you as I run 'Mail' in one space and Filemaker in another which doesn't seem to run faultlessly!

I'm trying to do exactly the same as this. Is there no send email function only a script? Is this still the best way to do this task as I don't really like the idea of installing 3rd part plug-ins unless absolutely necessary. I would presumably have to install the plugin on all client machines?

Thanks for everyone's help on this. :beertime

Tried your calculation replacing date1 and date2 in your calculation with the 'from' and 'to' dates in my database but the first line is coming up with the 'There are too few parameters in this function' message!

Should hopefully be a very quick one here for one of you super clever dudes! Is there a calculation that will give the total number of week days (excluding weekends within a given period?

I'm trying to create an IT Support database for a small amount of users 30+ and this seems a bit longwinded. There must be a relatively straight forward script that ideally says find all records for the currently logged in user? If not I need a script that says if user name is John Smith find all records for John Smith etc all the way through the staff list? I would much appreciate some further help on this. Thanks.

I'm trying to setup a login script that will find all records created by that user on login. Is there a generic calculation rather than setting up a long winded 'case' script for every user? I addition to this it would be great if named system administrators could see all records on login? Thanks for your help.

Thanks very much for that. Sorted now!!

There must be a very simple way of doing this i.e. 1 should be 01, 2 should be 02, etc? These two sequential digits are the last part of a product code created using global fields. The whole code is dependent on the criteria of the product and so cannot be just one long stream of sequential codes. Any help on this would be greatly appreciated.