Tmonk

Thanks for the suggestions. I will try what you suggested after reviewing the the info on the link.

I'm using a G5 / OS 10.4 and fm is up to date. I created a self join with the financials table. I enter data into the second instance and it updates records in the portal(the original table) All other fields update except the calc. I can't/haven't figure it out..?? yet

How about using the Case function in place of the If

Hello! I have a calc field that determines a discount based on a global field that represents the registration fee of a "league type" and the actual fee paid. It is unstored, and in a table called "financials" I have a "players" layout with a portal for financials. Now here's what's driving me bonkers.. The calc works fine when I open the app and use it on a windows machine. However, on a Mac it will not work. If I go directly to a financial layout(not to the portal) and enter data, it works just fine(on the mac)but not on the players layout. Can someone make a suggestion as to what might be the problem, or where to begin trouble shooting. Thanks.

Sorry about not answering the feb 11 question. Looking through the date field in my exported file it appears as "2006 211". I am going to try your suggestions. Thanks!

I have no control over how the customer program formats its data when exporting. I am trying to take that data and import it into a fm app. However, what is happening on export is that all the date info is formatting two ways at the same time . Some records show up as "mm/dd/yyyy" (12/21/2006) and others "yyyy mmdd" (2006 111). I don't know why this is and I have no control over it. When I try to import this field into a fm app all the "yyyy mmdd" dates are left blank for that record. Since the date is formatted in two different ways across all the records I'm looking for a way to correct that on import.

I'm trying to create a program that will take the data from our custumer management app and allow us to run a monthly tax due report. However, when the "payment date" data is exported from the custumer management app(not a fm app) it is formatted in one of two ways in the same field. Ex. 12/1/2006, which imports into my fm app fine, but the other way it is formatted,ex. 2007 112, does not. The program dumps the data in dbf format. Is there a way that during the import data step, I can change the date to import properly. Thanks

Hi!I am having a problem with a calculation not working with the layout I need it to work on. I have 2 tables, Player, and Financial. There is a second instance of Financial called "Enter Financial". I have a layout whose primary table is Player. There is a portal where records from financial are listed. I have fields on my "Player Layout" where I enter data in fields from "Enter Financial" which then update my financial fields in the portal. No problem there...EXCEPT a calculation(calc discount) that is supposed to update a field called "discount" which doesn't work. However, if I create a layout with Financial as my primary table, and enter data into the fields, the calculation works fine, and updates the "discount" field in my financial table. Any suggestions would be greatly appreciated. Thanks in advance!

Thanks!

Sorry, after rereading my original post I don't think I explained myself well. What I'm looking for is the first part of the count. Record (x) of 5 or (x) of 9. So that the user can scroll from the first record (1) to the last.

I would like to emulate the records counter on the staus bar w/o the bar. I've used Status (current found count) which shows me the correct found set of records. But if I use Status( current record number) it will only give me the proper record number of the found set in browse mode if all records are available. Fer instance, when I perform a find the total number of found records count is correct but the record number (1 of3, 2of3, etc. reflects the record number of the record in the "complete" record set. Any suggestions?

I have a script that is returning "no records found" even when it finds records. When I remove the steps with my message box it runs fine but doesn't tell the user if no records were found. I've attached it as a pdf. Can someone explain what step(s) are incorrect. CoachInfo.PDF

OK. Please bear with me as I try to underdstand. Even though I have a relationship setup between my main file and the registration file and the portal used on my main file layout accuratley displays related info; a perform find will not be able to see the related info from my related file? (sorry for the long sentence) Could you elaborate for me what a filtered portal and list layout are ? Thanks for your help.

All key fields are indexed and stored and same type(text,auto enter a serial number). My main file "player info" has a relationship with a file named "registration info". I would like to run this report from my main file because it has all the layouts there. What i can't understand is when I open the Registration file and create a report/ layout I can enter the date ranges and it works fine. I should note that when I manually enter the date ranges on my Main(player info) file I get the same results as if I run the script. I'm totally confused.

Interesting. I have tried all of your checks. The script is passing the date range into the field properly but still returning all records, rather then just those in the date range. Also, when dates are entered manually, I get the same result! I have my payment field set up as a date field with strict 4 year validation. Does it matter that some of the files, including the Payment date field are in a related file? When I tried making a report in the Registration "Paid file" I seem to have no problems. However, when I try running the report from my Master file it just doesn't work.Could it be a relationship setup error?

This is getting me closer. Ihave used the first four lines of the script you've provided on a button that takes me to the "date range" layout. I can then enter the approriate date ranges and use another button to begin the remainder of the script. However, even though i specify date criteria "01/01/03", "12/31/03" for instance, the records that appear on my report layout show other years then those specified. I'm using a layout(report) named "accounts receivable" where you specify "layout with the date_paid field on it". This report contains among other fileds a "payment date" field, which is the field i am performing the find on in the insert calc result step.

I am still unable to get this to work. Maybe I'm confusing some of the script steps that won't work with the ones you've suggested. Or more likely, I'm confused...

I hope I'm in the right forum. I need to specify criteria before a report is run. For instance, if I want to look at all registration paid in a particular year, rather then have all registrations from all years run. Is it possible to create a message box that will prompt a user to enter a date range for the year they wish to retrieve?

Thank you for your suggestion. I'm using a shovel where a spoon would suffice!

OK. I have experimented and came up with something that works when my "coachinfo" file is open. It's a calc field based on a maching phone# between coach and family. If a match is found it opens one layout, if not another. However, under "player info" where my main layout is, I can't seem to get this to work properly. I've attached the files to this response. If this helps better explain what I'm doing wrong, I'll take any suggestions. Thanks.

I'm working on a db for our little league baseball organization. I've had some good suggestions from the posts I've sent up and through browsing the threads. I'm hoping someone can help with a relation question. Creating databases is not my "day job" and consequently I'm probably asking a silly question. I have a Player ID file, Registration file, Family File, and a Coach File. The fields in the Player ID are specific to each player(ID,dob,calc. age, etc) Since more then one player can come from one family I separated the family file to contain info relating to a family. I use "phone" as a match to fill in the family info(if it already exists) on my main layout when adding a new player.(works) I have my registration info in a portal on the main layout that identifies financial info about each player. (works) What I can't seem to figure out is how to use the family file to help fill in related info in my coach file. Most people who coach will be included in the family list because they have kids in the league, however there are coaches who are just coaches. When I got this to semi- work, a coach who wasn't part of "family" would be added to family because of the way my relationship was set. If I disabled "allow creation of related files" I could not enter data in the fields where my data came from "family" that didn't already exist in the family file. Another issue was if I deleted a coach who also had player info related to my family file, it would delete all my player info related to that family but not the family info! I'm struggling to make sense of it all!

Looking through the threads I've seen this asked in similar ways so forgive this question. I have a field where I want the user to enter the "year" only. Not "2/21/2003". I tried formating the fields to show only the year, but fm asks for the user to enter the complete date. I could set the field as a number or date field, but I'm afraid that might cause validation problems down the road when I'll have to sort on the field. Is there a message box that could be used to prompt the user? I'm very new to fm and would appreciate any guidence on this issue.

I have a portal on my "main" layout that shows "registration paid info" from a related file. I would like to be able to tab into the portal to a new record, rather then into the first field of an existing record. Can someone help me with this? Thanks.

Ok. Please note I am very new to FM with little experience. I have created several files where the relationships work fine. Now, I'm trying to create a layout that will give someone the ability to find a record by either Last name, Id number, or phone number.(I have defined all these fields) I want to give them the choice on which search would work best. Once a record is found, or group of records, I would like the layout to switch to the "PlayerInfo" layout to either view the record(s) or be able to edit.Can anyone lead me down the path of knowledge, or at least to the front door?

Thanks! That was revealing !