Islandtraveler

THANK you for responding... To clear it up: DB1 holds the item description and related info and 6 fields relating to locations where that item may be located, it is a quick reference and shows a total of all the sites too. To keep installers from getting into that area i created a second DB to track who takes or moves items in or out of locations (in this DB2 I create a record each time they input the changes. THIS is where I would like the fields to be updated in DB1 to either add to a number or with a negative remove from the stock level (without creating a new record there). I had it create a new record every time and then do running totals which worked if I did it, BUT if they forgot to sort or find a specific item everytime it would do running totals with odd results (as other items or older records were showing) so even with buttons scripted to sort and such for them, they still find a way to mess up. I then wanted to do it this new way to clean it up. Hope that helps THANKS!!

PLEASE. even if you think it won't work... Let me know. I REALLY need to get this done and if I can't update a field by adding to the number already there I would like to know I'm going down the wrong road. Thanks

For some reason my mind is slipping.. I have an inventory database with each record identifying an item and several fields with qty of that item in different locations. I have a second database where people input changes to the stock locations (this tracks the inputter by records and their actions). I want to input numbers in the second database and have it add to the field in the first without creating a new record there. Any help please?

Thanks but it didn't come back with a way to do what I am looking for... I will keep looking ! Thanks for the response!

Is there a way to have the value lists for say different depatments limit the list to that account login. I have a large company with multiple programs so if someone in Health logs in under health I want only the health related divisions to show in the division drop down list, same with other departments... Can it be done? Thanks

That's it... I was trying to use them in a field not a text box! You made my day! Thanks

I know this has to be easy but it is giving me a hard time! All I want to do is date stamp a report with the current date when it is printed each time. Please help my brain is hurting...

: Well it worked for me THANKS!!! been reloading the thing for half a day!

Thanks for the info and temp... I need to let this soak in and will take a deep look at it in the morning! It's 1:30am here and I'm a bit in a daze. Thanks for the input and samples, I'll see if it does it for me tomorrow. Take care

Well it does look the same on the relationship section (3 compared to my 4) BUT doesn't quite address my problem. If I do a find with only 2 of the 4 fields linked to the other database it just doesn't get the related records from database 2. Even if the other 2 fields are empty in both databases?? I can't figure out how to build the relationship to allow it to know if the field is blank to ignore it? The options are basic = less than greater than etc. Any clues *My quick fix was to add an "n/a" in the fields I am not using for that record but I would like nothing to be in the field if I am not using it... Thanks for your time

Thanks... I am tracking an agency that has 4 levels of a department, Ministry - Bureau - Division - Program There are goals for each, sometimes they want a goal for the Program level (using all 4 fields) and then at times they want the top levels only (which do have seperate goals too). I have the main DB that if you find using all four M-B-D-P it brings over information relating to that. BUT there are some goals that only relate to the top level so I do a find on just the M-B (the other field are empty. But because I told the DBs to relate all four fields to match it does not bring the related records that only have the two fields filled in? Does that help? Thanks

HELP... I have 2 databases and they are linked with 4 relationships (A=A and B=B and C=C and D=D) If all 4 are filled in no problem it matches the records BUT if only 2 of the 4 relationships are filled in (other two are blank in both DBs) then it can't find the records?? How can I set it up to realize 2 are blank but they match and the records are looked up? Thanks

Very cool ... Thank you so much!!

Is there a way to have a button take you to a specified layout but then also to a certain tab on that layout? Thanks

Thanks... that worked and one other way too... Appreciate it!

I am looking for a way to have a button or field change color if there is text in a different field? I have a button to go to a layout for comments but on the original layout you can't tell if there are any comments already... I would like the button or a flag field to change colors if there is text in the comment field without going there. (I can get a flag field to say yes or no but would rather change the color ) eye candy I guess... Thanks

:clap: THANK YOU... THAT DID IT... SO SIMPLE I MISSED IT OVER AND OVER! Thanks again for your help!

I'm sorry but let me ask a followup, I think I know what you are saying but not sure this is it... here is a picture of what I mean. Say 4 records were found: Goal 1 (text) Objective 1.1 (text) Activity 1.1.1 (supplies = $5000, Other = $2000) ______________ Goal 1 (text) Objective 1.1 (text) Activity 1.1.2 (supplies = $500, Other = $500) ______________ Goal 1 (text) Objective 2.1 (text) Activity 2.1.1 (supplies = $1000, Other = $1000) ______________ Goal 1 (text) Objective 2.1 (text) Activity 2.1.2 (supplies = $2000, Other = $500) ______________ What I want to see is: ____________________________________ Goal 1 (text) Objective 1.1 (text) Total = Supplies = $5500 Other = $2500 (running) Objective 2.1 (text) Total = Supplies = $3000 Other = $1500 (running) Then Goal 2 etc. _________________________________ If I do the layouts like you say How do I keep the single Objective 1.1 and Objective 2.1 (without the other 1.1 and 2.1 showing also? Thanks

: I have a database with multiple layers of data.. ie. one goal(1), three objectives(1.1), four activities(1.1.1) (the records are at the activity level) so there are many records with the same goal and objectives. For one report I just wanted to see Goals and Objectives so I ran a script that pulled all the records sorted them and then Omited the duplicates at the objective level! Works great BUT it drops say 40 records down to 13. Now I need to do a report that gets a running total of the financial information for each objective BUT the financial data relate to the activity. I have it worked out on the report to get the info there with the 40 records (using sub-summaries that show the goal under it the objective and then only the totals of several catagories of dollar figures (added up from all the activity inputs) BUT without the omit script I have to see lots of Objectives 1.1 repeated on the report?and if I run the script it drops the records (and the financial data) from the hidden activity info... Any way I can do this right?

Sorry the link for the instructions was not complete above... to long I guess? make sure you add the second line to this link ( .html ) http://homepage.mac.com/car1son/change_apache_port .html

Thanks for the effort and info, Port 591 is used as one that FM has identified /reserved for it's use (which you knew) and as I have a web server already on Port 80 I configured FM on 591... For anyone else in need of this... I did get the port changed done and yes I had to change the Apache web server (built into Mac OSX) to listen on port 591. Not real easy only because the file is hidden and I needed an app to make it visible (I'm not to up on the Terminal access) I used Mac Pilot for that, then had to open the file with a cocoa text editor which I used Smultron and made the one change from 80 to 591... restarted the server and away it went! Thanks again for the clue! Here is a link to the instruction that worked for me. http://homepage.mac.com/car1son/change_apache_port.html

I have just installed FM Server 8 Advanced and need to run the IWP on port 591 instead of port 80... Where/how do I change it? It was working on my FMP 8.5 Advanced setup. Thanks

Got it... I use the "Set Field" command instead and it does what I was looking for... Only replaces the info in the new record!!! Yeah Thanks All!

Thanks, but I don't always want a new records to show the last viewed information... Wouldn't it then even if I say New Record (starting from scratch or other user) get whatever was looked at before instead of a clean layout with blank fields? Thanks Jim

I am trying to do a script that will duplicate a record and keep some fields but empty others for new data, my problem is that the Replace Field Contents option then replaces the fields in the original record too?? Is there a way to do this? Help!!