Jump to content

cuttysark

Newbies
  • Posts

    5
  • Joined

  • Last visited

cuttysark's Achievements

Rookie

Rookie (2/14)

  • First Post
  • Conversation Starter
  • Week One Done
  • One Month Later
  • One Year In

Recent Badges

0

Reputation

  1. Hello, I am trying to sort records based on a summary field from a related table, but FM9 won't seem to do it. I have a table JOBS, a table CONTRACTORS. Each job can have one contractor. In the JOBS table, I also have a summary field TOTAL_JOBS, which is a COUNT OF JOB_ID (unique id field). I have set up another table occurence of both CONTRACTORS and JOBS, and want to view how many jobs each contractor has done, then sort them by that number. I'm in a list layout, and have all the contractors listed. Next to that, the related summary field JOBS::TOTAL_JOBS, which displays the correct number of total jobs done by each contractor. However, I can't for the life of me get the list to sort by the summary field. I've tried sorting by contractor name and then "Reorder based on Summary field", but this doesn't seem to do anything. Can anyone show me where I'm going wrong? Thank you for your help.
  2. OK, I managed to figure it out myself. I needed to make another occurence of the PIC table, and added to the PIC table a unique ID number as a primary key. I then added the same ID number to the Company table as a foreign key, and created a relationship between the two. All is working fine now!
  3. Hi, I'm pretty new to FM, so I hope this is the right forum. I have 3 tables in my database: Jobs, Companies, and PIC (Person in charge). Each Job is performed by one Company. Each Company has several PIC's. Therefore, I have related Jobs and Companies through the "Company Name". Companies and PICs are related through the "Company ID#". The user looking at the Jobs database can select a Company for the Job by pulling down a drop-down list with a value list based on the "Company Name" field. The appropriate information fields about the company then display as static fields in a portal. However, I want the user to also be able to select one of the the PICs from that Company to deal with the specific Job. I tried making a value list drop-down menu showing related values (the PIC's surname) - the list shows up fine, but when I select a PIC's surname, all it does is change the name of the first PIC attached to that Company to whatever surname I selected. What I want it to do is update the display of other fields to show the details of the 2nd, 3rd, 4th etc PIC, based on the surname selected in the drop-down menu. Can anyone offer a suggestion on how to do this? Many, many thanks in advance. Cuttysark
  4. That works great, thanks! I don't think you could do it much more simply or elegantly - I just missed the fact that turning the radio button into a calculation would do the trick. Thanks again!
  5. Hi All I am still a complete beginner, so I expect this is a fairly simple problem. I have a drop-down menu with options "beef", "pork", "salad", "fruit" and a radio button set with options "meat", "vegetarian". If the user selects "beef" or "pork" from the drop-down menu, I'd like the radio button "meat" to be automatically selected. If they select "salad" or "fruit", I'd like the button to switch to "vegetarian". Is this possible? Thanks for your help and patience.
×
×
  • Create New...

Important Information

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