Jump to content

Myron S.

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Myron S.

  • Rank
  1. Yes, that was the solution to this problem. Thank you so much.
  2. Actually, I was trying to make it look like this: Time: 8:00 • Location A: 3 passengers Time: 8:30 • Location B: 7 passengers Time: 9:45 • Location C: 4 passengers Time: 9:45 • Location D: 2 passengers
  3. Thanks for your response. Sorry I wasn't more clear. Here are the actual circumstances: This is a tour bus operation which picks up 50 passengers on a given tour. Each one of the 50 passenger records has a pickup location field (PU_LOC) and a pickup time field(PU_TIME). My need is to run a report summarizing the number of passengers that are to be picked up at each of the 5 pickup locations, sorted by pickup time in ascending order, from the earliest time to the latest. The problem is that two out of the five pickup locations have the exact same time, so when I run the report, only 4 o
  4. Hi there, Is there any way to prevent records from being omitted during preview mode or when printing reports where the subsummary field is identical accross several records? I'm running a report regarding time schedules where the Sub-summary part is set as "sub-summary when sorted by: Time." The problem is that in this report there are several records with different activities taking place at the same time, but when I print or preview the report only one record is showing. Thanks in advance for your help
  5. Looks like that's the answer. Thank you so much for your help :-)
  6. Yes, I think you've got it. The Vendors -< Services 2 should only include specific records based on the value in the StatusCode field, which needs to update when the grandparent Reservation status changes.
  7. I'll try to explain it better, but it might sound complicated: In my travel business I have a RESERVATIONS table. With each reservation record there are related PASSENGERS. For each passenger there are related SERVICES offered by vendors on the trip, such as restaurants with meal choices. In the RESERVATION table, a StatusCode field indicates the status of the reservation, for example: Paid in full = 1, Pending Payment = 2, waitlist = 3, and so on. Each SERVICE line item associated with the Reservation also has a StatusCode field that needs to reflect the value of the StausCode field in
  8. Hi there, I am trying to have a field in table 2 reference and take on the value of a field in related table 1 whenever table 1 changes in order to dynamically establish another relationship for table 2 on the right side of a different table occurrance. I know I can't use a calculation field for the relationship, so I though that maybe a number field with an auto-enter calculation would do the trick, but it doesn't. Any idea how I can have the field in the right-hand side of a relationship take the value of a field in the left-hand table as it changes without making it a calculation field? O
  9. Hi there, I'm trying to figure out the best way to do this: I have a "Passengers" table on a trip. Each passenger must choose several options from a list of "vendorServices" related to a "Vendor" table (for example, there are 5 vendors on this trip, each offering 3 meal choices. Every passenger must choose one option from each of the 5 vendors). The process of selecting the options is currently in place and when a selection is made, a related record is created for that passenger in a "Passenger Options" table. When completed successfully, each passenger will have 5 line items in the relate
  10. Sorry for the double post, my mistake. I had intended to add to the thread on the second post and just ask if there was an equivelent to Get(ActiveRecord)as a possible work around but posted incorrectly. my appologies. Thanks for your replies.
  11. I'm trying to use conditional formating to highlight a field in the active record during list view. Is there a function equivilent of Get(ActiveRecord)or some other way to achieve this through conditional formating?
  12. Hi there, I was wondering if someone could tell me how to use conditional formatting in FM9 to highlight the row of the active record in list view. Thanks in advance.
  13. I'm wondering if there is a simple calculation formula for this: I have field that auto-enters a unique calculated "tourcode" for a bus excursion on a particular date. The code always ends with the letter "A" when there is only one bus for that excursion on that date. However, when there is more than one bus going to the same event, the code is the same except that it ends in "B", "C", etc., to identify the second, third or more buses. Is there a simple calculation or function that I can use in this field to automatically place the appropriate letter "A" through "Z" at the end of the c
  14. Thank you both for your replies. My case is as you described, Soren, whereby a particular single invoice order needs to automatically generate several line items, each being a snapshot of the pricing of the line item at the time the order is created. Under these circumstances, would you recommend an export of the found set? If so, is it possible to export directly to a table in the same file? Or Perhaps you can suggest a more elegant way to create these new line item records.
  15. Hi there, I'm trying to figure out the cleanest way to create a set of new records in one table based on the found set in another table. I have a table containing TEMPLATE records, or records that are used for the sole purpose of populating new records in another table. From a FOUND SET of records in the TEMPLATE table (3-20 records at any given time), I need to create an equal number of new identical records in a DESTINATION table. What would be the best way to do this? Is there a way to reach out from the DESTINATION table and step through the found set or does it have to
  • Create New...

Important Information

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