Jump to content


  • Posts

  • Joined

  • Last visited

johnlyons's Achievements


Apprentice (3/14)

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

Recent Badges



  1. I have entered all my data in lower case and now would like to chane to upper case in all layouts. I can do this manually but when I export the data even though in all alyouts it is now uppercase it still exports as lower case.
  2. In a layout I have a portal with a field model and then dimesion fields A,B,C,D. pending on the model entered then various fields must be filled in as mandatory. Example: if Model 'E90' then only field A must be filled. If model 'TR' then fields A,B,C must be filled. If Model 'TC' Then fields A & C must be filled. Can the this be done so if these fields are not filled then a message appears?
  3. Is there a way to expand a field within a portal to the amount of text that is entered. If this is possible then I am also wondering if the defined portal area could also expand to the size of the expanding fields.
  4. I am having trouble with the following: Lookup based on Sell price with a relationship between 2 tables on Model, A & B fields. Here is an example of some data Model A B Sell Price SRAC 6 12 $4.42 SRAC 8 8 $4.21 SRAC 8 12 $4.76 When I enter: Model A B Sell Price SRAC 7 12 I get Sell Price = $4.21 which is how the 'Copy Next Higher value' is working. I would prefer to get the result of $4.76 so in theory the system would first match on Model, then on A, then on B. If B wasn't matched it would then take the next higher value of B. Can this be done?
  5. Thank You. this worked. My backets were in the wrong places.
  6. I would like to create a staement that would read like If(X>100 or Y >100) XXXX;YYYY I am having problems withe the 'or'. I guess this is not used in FM. How would I get this statement to go? Thanks
  7. This worked to perfection! Thanks for the help!
  8. I am in a layout list in browse mode which shows 12 records from a find. I would like to place cursor over one of the 12 records making this the active record and then go to a new layout which would show only this record. I can get to the new layout and see this record but the record is one of 12 still in the found set. I would like to have this current record be the only found one. Can you somehow find on the active record?
  9. This worked. Thank you all for the help.
  10. Sorry for the confusion hopefully this explains things better. If I have bid with the following dates 11/1/05 11/20/05 12/21/05 1/02/06 1/05/06 1/10/06 today being 1/4/06 and today-6 being 12/29/06 I would like to retrieve all quotes >today-6 which from the example would return 1/02/06, 1/05/06 & 1/10/06. Thanks for sticking with me on this one.
  11. I have a list of bids with due dates that range from years ago to dates in the future. I want to find all bids that are greater than todays date - 6 days ago. I believe the solution provided earlier will only give me the bids for the date of today-6. Thanks for your help
  12. I didn't state my question correctly. I would like to find all records >todays date-6. can this be done?
  13. I would like to create a script to attach to a lyout that would find all records that have a date of todays date - 6 days. I am stuck. please help. thanks
  • Create New...

Important Information

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