dbman

Thanks Fitch, One place I found it was in the field definitions of the Time Billing templates provided with FMP 5.5 as part of the sample files. I have used those templated and modified it for a different use but none of the filed highlight. I'm not sure if it is a unque field lableing method, but I have seen it on other sample DBs download from the net. I'm still not sure if the name has any significance. Any help is still appreciated. Mike T Eugene, OR

Sorry that this may be such a newbie question. Several documents and many templates and sample DBs have field name with the preface of Hilite, generally for a calcualtion field. What does hilite signify since it isn't listed as a specific calc funtion? I would like to be able to understand designers intent of their calcs so I can learn but this Hhilite stumps me. Please help, thank you. Mike T

Thanks Bob. I'll give the two formulas a try. Mike T

I'm brain dead and felt so close to a likely easy solution. Excuse me if this is too wordy. Have an invoice/receipt file and the line item area is a portal. The child file Item record's capture the date and invoice number of the related parent Invoice record. Our fiscal year (FY) is not calendar but 7/1/01 to 6/30/02. I want to generate revenue reports for this off set FY. I thought I could would create a calc field "FY", which would be a nested If calc. To start I tried a non nested approach. Depending on date arrangement, or adding "" in different places I either had every date over a three year peroid indicate "FY 01" in the FY field or nothing. Examples: 1. If(Date >=7/1/2000 and Date <= 6/30/2001, "FY 01", "" 2. If(Date <=6/30/2001 and Date >=7/1/2000 , "FY 01", "" 3. If("Date <=6/30/2001 and Date >=7/1/2000" , "FY 01", "" 4. If("Date <=6/30/2001" and "Date >=7/1/2000" , "FY 01", "" 5. etc. I'm trying to get the FY field to recognized the date of ecah new item record and provide the correct FY. In the mean time, for my script, I perform a date range find for one FY set a global with FY 01, let's say, conduct a sort for the report and use the global in the Grand summary to identify the year of the report. This works OK for single reports but I have had to create numerous scripts in order to cover all FYs instead of one script that will generate all FYs. Any ideas or other approaches? Mike, and thanks

I'll share what just worked for me. I was looking to secure each record and your intial message got me headed in the right direction. Since I had not seen norunderstood the formula you posted (please let me know what "!= " stands for since I may have a use for it later) I tried two appraoches and the second one is successful. Background: The DB is for reconciling Petty Cash within the office (about $1,000 per month, 30-40 transactions) The coin and currency accounting fields are part of the parent and the transactions for refunds are created through a portal. The Approval field is for management and read only to support staff. The field is a value list "JN" and "MCT", button style. After staff reconcils a day of transactions, a manager will select his intial which triggers a date and time stamp with hopes of locking the record from future changes. It works now. First attempt: I went to define Edit Records "Limited" in password access dialog box. I tried "If (Approved = "JN" or "MCT", 0, 1). It worked fine on my workstation in a sample DB. After applying it to the DB hosted on the server it would not acknowledge the formula and would not lock for the support staff password. Second Attempt: Used the following, "If(Is Empty(Approval), 1, "") . This locks the parent fields in the "approved" record but not the portal records. I'll try applying the formula to the portal records DB in the next day or two and see if selecting the Approval choice will trigger a lookup for a field in each portal record to engage the lock. I tried support staff's password on other workstations and the record lock works on the parent fields. I'm sorry this seems long but I haven't offered suggestions before and I did not want to miss any details. Hope it applys. Mike T

Thank you for the solution, I give it a try after meetings end this week. MT

quote: Originally posted by Tokyo-B: If I remember correctly , I think you have to put an underscore at the end of the name. i.e. mydb_.fmp This should prevent it from displaying... (Someone please correct me if I am wrong) Good Luck! [ January 04, 2002: Message edited by: Tokyo-B ]

What am I missing? I am running three related DBs on Win NT/FMP Server. The parent DB Invoice Master diplays customer info and the items,cost codes and costs are displayed with a portal from DB Invoice Cost Records (ICR). ICR is related to DB Cost Codes, where the short codes i.e. P-S, P-AS.... are associated to specific dollar amounts. Problem: When a user selects Invoice Master it opens the other two DBs which are viewable to the user (yes, they are initially hidden from the Host list using "multiuser-hidden"). I do not want the user to dink with these two DB's. Is there a way to keep them hidden? When I tried putting a few user restrictions on certain child DB fields the parent DB fileds would not operate properly. I hope I've provide enough info, thank you for any assistance.