MJG

I am sure it is easy and I am just missing something, but this script is giving me fits this morning. I am trying to run a script that will find all receipts created on a certain date, then print labels for them. I have created a separate label layout, and if I do it manually everything works fine. I want to be able to do everything with the click of a button and a simple input of the date though. When I do the process manually, I perform the following steps: 1. Open New Window 2. Go to Layout (Pre-Paid) 3. Go to Field (Receipt Date) 4. Find whatever date 5. Go to Layout (Pre-Paid Labels) 6. Print Like I said, that works fine, but I can't seem to get the user input part of the script. I can make it work if I want to just use the current date, but sometimes we want to print other days. Here is the current script I have, after messing with it for a few hours: Print Today's Pre-Paid Labels Show All Records New Window [ ] Go to Layout [ “Pre-Paid Labels” (Pre-Paid) ] Go to Field [ Pre-Paid::Receipt Date ] [ Select/perform ] Enter Find Mode [ ] [ Pause ] Go to Layout [ “Pre-Paid Labels” (Pre-Paid) ] Print [ Records being browsed; All Pages; Orientation: Portrait; Paper size: 8.5" x 11" ] [ Restore ] Close Window [ Current Window ] What's missing or what am I doing wrong? Thank you for any input. I have always received great replies to my posts and everyone has been very helpful to this FM novice. Mike

Thanks Ender, that did the trick.

I have never worked with FM server before, and am trying to move a file that was previously used locally on my computer. I want to have it on the server so it can be accessed by more than one person at a time. I moved the file to the FM 8 Server, and am able to access the file across the network, but I am unable to modify it. When I try to do any modification, I get an error that says "This action cannot be performed because this file is not modifiable." Before moving the file to the server, I created an admin login with full access, and a user login with write only access. This was done on the local file. I get the same error message with either login when connecting to the server, but it works fine when I am accessing the file locally. Was I supposed to configure something on the server? Basically all I did on the server was put the file into the databases folder, then start up server. What else do I have to do? Thanks for any help here. Mike

Bob, Thanks. That did the trick. Mike

Thanks for the help. That is basically what I tried first. I have: Case ( Ship State = MD ; MD Sales Tax = Item Total * .05{; Ship State ≠ MD; MD Sales Tax =0} ) However, when I try to save that as the definition for the field, it says that it can't find the MD field. Is there a way to say: if Ship State contains MD, then MD Sales Tax = Item Total * .05)? Not sure if using contains instead of = would make any difference. Again, any help would be appreciated. Mike

It seems like this should be a simple calculation, but I haven't worked with FM for a while and have never done too much with calculations. What I need to do is define a Sales Tax field that says: If the Ship To State = MD, Sales Tax = Item Subtotal * .05. I can't seem to figure that out using the options in FM though. I am using FM8. Thanks for any help. Mike

Is there a way to force capitalization in a field? Thanks

Thank you for your help guys.

Fitch, I think that is close. I guess I also need to include that if cost is empty or zero, price needs to be blank. Is that possible as well? Thanks Again.

I want to calculate price for an item based on cost. It works out as follows: If Cost is > or = $100, add $100, then round up to next $9.95. If Cost is < $100, double Cost, then round up to next $9.95. Does this make sense? Is there a way to do this using Price as a calculation? Thanks, in advance, for any feedback. Mike FileMaker Version: 5 Platform: Mac OS X Panther

Thanks for your responses. While I was waiting for a response, I figured it out. I did exactly what Andy said. I have nothing against using a script. I just was not sure if there was a check box somewhere that would do it. It is working great. Thanks

I want a to open all related files when I open one file. Is there a way to do this without using a script. If not, does anyone know how to create a script to do this? Thanks FileMaker Version: 5 Platform: Mac OS X Panther

I have recently created an inventory type database, and am now looking for a way to print code 39 barcodes directly from one of my files. What I have come up with so far is that I need a plugin and a barcode font. Is this correct? If so, does anyone have any recommendations for both plugins and barcode fonts? Thanks FileMaker Version: 5 Platform: Mac OS X Panther

I am a FM novice, and am trying to create an inventory system that has three parts, Received, Inventory, and Shipped. I am not sure how to procede. I have created the three databases, but am not sure how to get the calculations to work, and how the relationships need to work. Also, I have read on some other posts that you need to use four files. Items contains one record for each item (what does that mean, and how is it done?), which I do not have, Orders (my Shipped), contains 1 record for each order, Restock (my Received), and Line Items (my Inventory), where most of the data is kept. I think I need some more clarification about how this is supposed to work. Any input would be greatly appreciated Received Database. This database contains a record of all deliveries. It lists quantities of each different line item. The fields are: Date, Order #, Vendor, Item #, Quantity, Manufacturer, Description, Cost, Purchased for, Category, Item total cost, Line Item Total, Shipping, Tax, Grand Total. Ideally, quantites entered here would update those listed in the Inventory Database. The Received database would allow us to look up and track where individual orders came from. We would like to add new products (one's we haven't entered into the inventory database yet) to the inventory database from here. Basically, a barcode would be scanned, or entered by hand, and the Description, Manufacturer, and Category, would be pulled from Inventory. Inventory Database. This is where most of the data actually resides. Fields include: Item #, Description, Manufacturer, Cost Each, Retail Price Each, Quantity on Hand, Remaining Stock Value, Total Quantity Received, Total Quantity Shipped, and History. Total Quantity Received would look at Received and find all of a particular item #, then add up all quantities for that item. Total Quantity Shipped would do the same thing, except from Shipped. Quantity on hand would be Total Received - Total Shipped. History would be a record of every Received order number that contains that item, along with date, as well as a record of every Shipped order number and date. Shipped Database. Just like the Received Database, except for items leaving. I hope I have explained this clearly enough. I can attach samples if this would help. Again, any input would be helpful Version: v5.x Platform: Mac OS X Panther