YuChieh

got it. thank you.

I installed FM Server 8 on a development server and FM 8 Advanced on my PC. I coverted all current databases (in FM6) to FM 8 and put them on the server. I could open all databases except one. I went to the console to open that database, but it keeps closed. I got a messages. * FileMaker cannot share a file because FM network sharing is truned off. Where do I trun on the network sharing on the server? Thanks.

I do have FM7. Your suggestion woudln't work. Because there is value in the related field in all records. Some records are old so they don't exist in the "live job" table. I can't search by non-empty value of that related field. Thanks

We are using FM 6. Is it possible to put a PDF form in FileMaker, instead of just showing an icon? Thanks

I edited the question. not sure why it was posted twice. I understand the logic - Go to find mode in the "all jobs" table and search for records which have a corresponding related record in the other table. But not sure what exactly how to do so? Can you give me more direction? Thanks

I have 2 DBs and a relationship to link them by an ID number. DB1 contains only live jobs, for example 10 records in there. DB2 contains all jobs, for example 80 records in there. In DB2, how do I find those 10 records contained in DB1? Thanks

I use the look up table and check "lookup higher" and it works for ranges. I think everything works out fine now. Thank you all for the ideas and solutions!!

It's in Excel. So the formula changes by each cell.

Yes I know that. like record 1, 0.017, next 3 records is 0.018. then go aback to 0.017, next 3 records is 0.018 again. a few of them in the middle are 0.0175. I am not too sure how to write this kind of formula. Thanks

Hi, I used the look up table and it works fine, except one problem. 10 Sheets of paper = 1 OZ. If I had 80 sheets = 8 OZ, or 85 sheets = 8.5 OZ, I could find the Postage $ in the table. If I had 87 sheets of paper, weight = 8.7 OZ. The postage $ is not in the lookup table. I would need to do if weight >= 8 and weight < 8.5, if weight >= 8.5 and weight < 9, How do I do that? Thank you. rate.zip

Actually, they are not duplicate fields. We need to separate congress and senate lists, and they are linked via another db. Therefore, I do it this way. I will try your way - putting the rate in a lookup table (we are still using version6, so it's another DB). We already have way many databases; so I would like to avoid creating too many databases and try to have everything in one if possible. Thank you for the input.

I attached a FM file. It's the field "weight by ounces_congress". I can do up to weight = 65.5. I need to put in 10 more conditions, up to 71.5 (increment by 0.5). Thank you! Test.zip

I have a claculation field. I need to put over 100 conditions using Case(test1, result1, test2, result2,...) (unforuntally, there is no "regular rules" for these and I cannot use a formula.) After I put in all the possibilities, a message "too many operators...". I guess the program does not take that many conditions. What other options do I have to make this work? Thank you.

Replace Contents works. Again, thank you very much.

Sorry I didn't state the situation clearly. For this case, I think it's safe to use global field. 1. we don't need to keep these records permanently. once the values are calculated in the records, we print them out to keep. Then we clear them and ready for the next job. 2. only one person will process this and print the numbers out right away. so it shouldn't have any conflict. 3. it's exactly what I want - have that global field shared by all records. Thank you very much for pointing these conditions out by using global fields. I will pay more attention for future use. One more question. Now I try to do a script/button to "clear" the content of one field (not the global one) in all records at once. I tried "set field", "find/replace", "insert calculated results". But they all clear the content in only "current record", not all records. How do I set to clear off all records? Thank you.

Thanks for the input. I found a way. I set the DB2::Accounting as Global field. Then using scripts to copy DB1::Accounting and paste it into DB2. So the DB2::Accounting in all records will be populated. Thank you!!

Actually I found out, probably it's becuase the relationship is not working. I have it like this -- DB1::Accouting = DB2::Accouning However, DB2::Accounting is a blank field that I want to put the new value in (from DB1:Accounting). So the relationship is not really linked. make sense? Then how do I insert a value from one database into a blank field in the other database? Thanks

How do I set a new value into a field that applys to all records? I use a script, setfield function. And I called the value from another database using the relationship. It didn't do anything. If I did "copy/paste", it only pastes into the current records. Thanks

That's what I was guessing as well - using script. How do I setup "start-up" script, I always wonder? Is there a way to setup a script that can automatically run without clicking on the button? Thanks

Yes, I do see there are quite a few neat features in versoion 7 and 8. Unfortunately, upgrading is out of the question for us right now. So I will have to work with what I have.

What I have now - * Field1 is a calculation filed. * using auto-enter to populate Field1 value into Field2. but not working since both fields are blank when the record is created. What I want - auto populate Field2 = value of Field1 and Field2 can be modified Thanks

Thanks both for the reply. I didn't know auto-enter only works when a new record is created. In this case, my approches won't work. I cannot make Field2 a calculation field either because I want the ability to change the value in Field2. If I use script to set field and insert calculated result all that, is there a way that the script can automatically run when the database is open? I am not sure I can use "Relookup contents" command from the Records menu method. Because this is an open form to our users and they need to see the value there right away without clicking on anything. Thanks for the help.

hi, I have 2 fileds in the same database. Field1 is a calculation field. I would like to auto-enter the value from Field1 into Field2. I tried 2 different ways -- 1. in Define Fields, Field2, Options, Auto-Enter, Check “Calculated Value” box, put “Field1” in the calculation area. 2. I set up a relationship from the database to the database itself (linked by the unique field) in Define Fields, Field2, Options, Auto-Enter, Check “Looked-up value” box, select the relationship, then select Field1. neither works. Can anybody help?

thank you for the reply. So for these 3 fields, taxDC, taxMD, taxVA, I should set Auto_Entry, Calculated Value - State="xx". right? How to do the script to capture the new value if the state is changed? Also, how to set "run this script automatically when this layout is opened"? Thank you

Thanks for the reply. The Value list name is "yes", and the real value is "1". I did set the field to 1. Thanks