Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Hurlz

  • Rank
  1. Thank you rwoods and comment. rwoods, that did make sense. I apologise that my explanation wasn't very clear. I read the literature linked to and watched the anchor buoy videos to check I was working with this principal correctly - turns out I was. However, once the relationships in my database get somewhat complex, with interactions in many directions, my relationship table and TOs get messy, and hence portals don't look up correct information - I'm obviously getting confused. I have put together a basic schematic which I hope will more clearly convey what I am trying to achieve. I
  2. My problem is this: I have a range of related tables: Species related to Permits Species related to Ethics Applications Species related to Research Projects Projects (and Permits and Ethics Applications) are all related to other tables (eg people) Setting up the many-to-many relationships for these, FM creates new table occurrences for Projects (Projects 2) to relate to Species and for Permits (Permits 2) to relate to Species. On the Species layout with portals for each of these all works. Each portal shows the records to Species from Projects (2), Permits
  3. I have a related issue - can export from Web Direct to CSV, but no headings come with the data. Is there a simple workaround to fix this. Old solutions were to use Merge, but this puts " around fields for use when doing a mailmerge with MSword. The headers and data can be opened in excel, but all in one column, so no use.
  4. Hi Wim, Great. Thank you for that. That worked. Cheers
  5. I have wrestled with this, but am failing. I have Students and Supervisors. Supervisors can have more than 1 student, and students will definitely have more than one supervisor. I would like to look at a student record and see their supervisors, and look at a Supervisors record to see all their students. I am assuming this should be in a portal, but I am having trouble with the self joining aspect. I want to keep them in the one contacts list, as there are other tables (eg Events) that both students and supervisors and other contacts will relate to. That stuff all works well. I think
  6. Yes you are right it would. What you have done is perfect!! Thank you so much.
  7. Good question. As this is an overview document for senior management, I would envisage either a) divided into 3rds - one for each month of the quarter, or b) just the whole quarter coloured in.
  8. Hi there, I attach a sample database producing a Gantt chart for each day of the month supplied by directimpactsolutions.com Works brilliantly. However, I need to produce the same effect but for each calendar quarter (Q1 = Jan, Feb, March; Q2 = April, May, June; Q3 = July, Aug, Sept; Q4 = Oct, Nov, Dec). Can anyone advise on how to change this to produce something similar to the spreadsheet attached (used for display purposes only)? Thank you Gantt by Qtrs.xls Gantt Chart (unlocked).fmp12
  9. Thanks so much for that. All great except when I add the Div instead of Truncate as can be seen in the much simpler sample attached. The median values with Truncate for these 5 records are correct. with Div they aren't - what am I doing wrong? whitsunday_monitoring sample.fmp12
  10. thank you for that. I thought I had changed that for all calculations but had not. My apologies and sorry for not sending a simpler file too.
  11. Hi, in the attached database, we collect a range of readings per date. I need to calculate the median for each element (eg temperature, pH etc) across a range of dates. There is one record per date. The user will change the range of dates depending on what time period they want to view. The data doesn't need to be summarised by anything. I am most of the way there, thanks to this great post: https://www.briandunning.com/cf/298. I have run the script in that link on a field doing a summary list. However, the list doesn't seem to sort as specified in the script, and the median value re
  12. Ahhh, I see now. Thank you so much for a concise explanation. That makes sense and I was able to fix my issue. 😊
  13. Hi there, I am sure there is a really simple answer to this but I just can't crack it. I have two related tables: Property and AoPC. Each Property will belong in a particular AoPC. I have set up the relationship and a set of tabs on a layout in the AoPC table. Each tab has a portal showing particular properties in that AoPC depending on the value in another field in the Property table called Influence. The Portal Filter calculation is really simple: If(Property::Influence = "25m";"25m";""), with a different value for each portal. There are three possible values in the Influence fiel
  • Create New...

Important Information

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