Jump to content

wenzelj

Members
  • Posts

    28
  • Joined

  • Last visited

About wenzelj

  • Birthday 03/02/1978

wenzelj's Achievements

Explorer

Explorer (4/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges

0

Reputation

  1. A problem that I am running into is that the Age is already a calc. When I try to add the Text Color function to it the Result is a "?" Am I going to need two seperate fields or is there a way to combine the two calcs? Help would be appreciated. Thanks.
  2. The fields I have set are DOB(date) and then Age is a calc. I want the Age field to turn red when the person is a minor <18 yrs old. Hope this additional info helps.
  3. Am trying to use the text color function to Display Red when a person is under 18 yrs old. Having some questions about setting up the calc to achieve this. Help would be appreciated. Thanks
  4. Part of the problem lies within the fact that this relationship can exist for two different situations. One is for Primary and one for Secondary. It is not going to be necessarily one or the other. What I am trying to say is it differs depending upon the record.
  5. Here is a sample file of what I have been working with. Everything seems alright, just still trying to figure out the whole situation with having to enter the "policy number" before activating the other information in the relationship. I have a script set up on the Medical Policy Layout under "school insurance" that enters the information, yet this only happens when the policy number is already enter. Is there anyway to hit the button, activating the script and have all the information entered without having to enter the policy number prior. hope this is a little more clear now. students.zip
  6. I got the whole relationship thing figured out. But one more question. I have to have the related field filled in for this to work. Is this customary or could it have to do with a script that I run to fill the other fields associated with the file? Thanks
  7. I did this quickly at the end of work. I'll redo it and try it again later.
  8. here it is. pword user. the part with the relationship is between policy holder info on students and the record in the school file. any other questions please ask....
  9. When I create the relationship and enter the information all I get in the file where the info is supposed to be is "Name Insured Sec::Name School" or similar for each field in the record. None of the info comes out right. what am i doing wrong here?
  10. not quite sure about this one..... I am trying to have data in one file(File : (that will change occasionally, yet be necessary for each record in another file(File A)). I am not sure whether I should utilize a relationship or a portal as this is not something I have used before. Here is what I am trying to do: I need a school name, address, and policy # in file B(child) to be used in File A(Parent). There are similar fields in each file. any thoughts....
  11. Thanks for your help. I used your example Lee and everything works the way that I need it to. Just trying to automate some tasks instead of copy and paste. EDITED Any solutions to this one............ Another ? here. Trying to create a relationship with info that will change yearly, yet is required on my layout. Same story with the address, but I want to have another file with the information and relate it to the main file. With that in mind to be able to change the info in the address file and run a script to update the main. However when I created the relationship FMP would not respond. Not too sure if the relationship was created properly or if the process is too consuming??? any thoughts here..
  12. I need to figure an efficient way to duplicate data from one layout and get it to a second layout. my fields are address1, city1 , state1, zip1 and prim address, prim city, prim state, and prim zip. The majority of the time the original data will be the same and need to be entered in the prim fields. So what I want to do is figure a way to check a box and have the info duplicated into the prim fields. My thought was similar to those used with credit card billing info and shipping addresses. Check the box if the shipping address is the same as billing address. Any thoughts on how to go about this.......
  13. Dont worry I got it figured out. Forgot about the nonprinting feature. thanks
  14. The problem I have is with printing data where I have two fields that are overlapped. One is phone data entry and the other is a clac field to format the phone number. I want the formatted phone number to print and not the data entry field. Help would be appreciated. Thanks
  15. I figured out the problem. Thanks for the help.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.