Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Jo_In_Oz

  • Rank
  • Birthday December 23

Profile Information

  • Industry
  • Gender
  • Location
    Bramston Beach Queensland Australia
  • Interests
    Sustainability, Growing food, Eating food, Good movies

Contact Methods

  • Website URL
  • Skype

Recent Profile Visitors

1,750 profile views
  1. Perhaps the issue is, due to my inexperience, I have been lost on how to create the Sections, sub-sections and answer you describe, drawing questions from the master table . In my case there are 6 Sections, 91 sub-sections, approximately 1000 individual questions (not repeated anywhere). I think I am missing the point on how to the relate the records from sections to sub-sections. I think I have been thinking fields, rather than records, perhaps. I still get stuck thinking that each Indicator question needs to be hardwired to a field name in a table, rather than a record in the p
  2. I will want to summarise reports, so separate records for each answer is necessary. The seemingly attempt to create seperate tables for categories was more of an attempt to display the kinds of questions/data I am dealing with, and in the case of the indicators, not committing all indicators to one table until I am confident of how to work with and display the data. Some fields may need to be repeated as there are a number of entries required such as Materials used, which will usually have a number of different types and amounts (weights) of materials used. and Is it poss
  3. I have a table called GRI codes that has all the 91 records of the 91 sub-categories. I use the Global Reporting Initiative (GRI) codes to standardise reporting to a globally accepted practice. If I put all the Indicators in one table (yes, indeed hundreds of them), I will need to identify which ones are associated with respective GRI codes (the 91). Is there any danger in adding the GRI prefix, for example EN01, to field names related to the sub-categories eg EN01? I note in a previous comment you mentioned this was not advisable. My lack of experience with FMP presents a road block in t
  4. Thank you! As I have continued to work on this I have come to a similar diagram. I have been experimenting with 6 tabs for the main categories/subjects on the client_indicator/response layout. Each tab has, for experimental purposes, 9 slides with portals related to the sub-categories with the respective indicator fields showing. What do you think?
  5. I was thinking of setting up 6 tabs to display 6 main categories, then 9 slides in each tab, with portals related to 9 tables requiring data entry. Will this work? So far I have not been able enter data in the portal/s. This could be my own lack of experience with portals though.
  6. I have included EN01 Indicator questions from the sub-categories related to the main category of EN, being for environmental indicators, to show the kind of questions asked. These questions could have Yes/No buttons. The relationship image shows the the graph when I made the FMP_Cl layout in the previous post. This is where I was trying out a child table to both clients and indicators with layout including a portal from indicators. It worked ok but I couldn't get it to automatically generate the records per client. What I am hoping to achieve is that I can use one layout that is chil
  7. Thank you so much for your time and effort in replies. I will attach a few images that will hopefully clarify what I am working with. I am the user at the moment. I will go to businesses and assess their levels of sustainability based on the widely accepted GRI (Global Reporting Initiative) documents. To do this I have extracted the dry data requirements held within the GRI and I am also developing questions of a more practical nature to apply during visits to businesses (with my iPad), rather than relying purely on GRI driven data. My aim is to develop a system that can report
  8. Hi comment, I didn't get into detail as it gets a bit confusing so I tried to give an example. Here is my situation in full: I am setting up a sustainability assessment database and am new to FMP, and I am not sure on the best way to set things up. I have 6 main assessment categories arising from economic, environment and social issues. These categories have a collective 91 sub-categories. The first main category, EC for economic, has 9 sub-categories. The second main category (EN for environment) has 34 and the last 4 are categories based on social indicators with sub-categories ra
  9. Thanks for all your help with the above. Perhaps another way of describing my situation is as follows: If a database had a services table with six different categories of services, and each category had variations, from 9 up to 34, totalling 91 categories, and each of those categories had a number of fields requiring data input, both qualitative for example pricing and qualitative for example quality of service, how would this be set up in a table so the user can choose particular services to enter data on? I keep coming back to the need to create tables for each of the 91 categories.
  10. I set up following your instructions. I am not sure where to place the fields that hold the questions. If in the 'questions' table, then I need to have the 'person' foreign key there I guess. My first sub-category (of 91) has 10 questions that require data input into the question fields. If I populate the questions layout with all the questions it will ge very long. Or do I start at the top, at person or category, and work my way down through droplists or similar. The questions need to be stored somewhere. Where do you suggest?
  11. The term zero to many is new to me. From what I have picked up it is the same as one to many with the option of one being zero, ie an empty field. This is perfect for me as not every person will answer every question. Makes no difference to the set up though, does it?
  12. Thanks for the links Kris M. There shouldn't be too much in the way of calculations, just relationships linking records together. Thanks dwdata, that does make sense. I am new and don't have a great grasp of how things link up yet, but your solution gives me a broader idea of what I can do. I will try it out! In the meantime, here is a summary of sorts, of where I have travelled so far in my first adventure with FMP. I have only constructed one table on the question side of things, so far, to experiment with. It represents one sub-catergory (called EN01) of 9 in the main categ
  13. Is there a limit to how many fields a table should have? My solution requires the management of 6 categories. Each category has up to 34 sub-categories, although most have 9-12, and each sub-category has several items requiring data entry. This leads to 91 sub-categories and hundreds of fields requiring data entry. The records per sub-category require relationships to corresponding sub-categories that respond to the data recorded. It is like a question/answer system, so the initial question field has data entered that requires answers entered and/or available (from previous experience) in
  14. A tad ambitious, but worth it in the long run to keep records together and to allow for a growing database of information as the knowledge base on actions to address unsustainable practices grows. Once the Indicator side of the solution is under control, then the actions to those measurements needs to be implemented. This side will grow as the knowledge base grows. I will keep plugging away at it, although any help will be greatly appreciated. Thanks.
  • Create New...

Important Information

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