Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Rramjet

  • Rank

Profile Information

  • Gender
    Not Telling
  1. So I have had a look at the solutions you pointed to Comment and there is some promise in them, however there are some problems I have with them: First, in the demo files, questions in the same survey have the same response set across all questions, but in my surveys the response set varies across questions. Second,I have free text responses mixed in with the standard questions. Third, (and it may just be me) but the demo files seem to be locked so that I cannot see the calculations, scripts, relationships or experiment with them in any way at all - is there a reason/solution for that? Re
  2. Okay, sorry for not being clear …I’ll try again… For one client there are: Eight possible survey types: Survey_1 Survey_2 Survey_3 Survey_4 Survey_5 Survey_6 Survey_7 Survey_8 Each survey can be conducted by 5 different respondents (completing the survey in reference to the client): Survey_1 (parent_1) Survey_1 (parent_2) Survey_1 (teacher) Survey_1 (self – is the client...) Survey_1 (Other) Survey_2 (etc) … … Each respondent can complete a survey for one of three age groups: Survey_1 (parent_1) (1-3) Survey_1 (parent_1) (4-7) Survey
  3. Perhaps I should have included a screenshot up front... For the SDQ outcome measure, at Assessment, for a Carer, who completes for the 3-4 age group you can see the fields needed. The Teacher, Parent, Self, etc are slightly different in that different questions are asked reflecting their status - so I need 3 x the agegroup fields plus all those again for the respondent type - and then I basically have to repeat those for all time points. My initial thought was, because all time points basically ask for the same information, I could simply duplicate the Assessment table (with som
  4. Okay, perhaps I have not explained clearly enough. Above the tab structure I have client info (Name, DOB, etc) Then the tab structure under that: LEVEL 1: Outcome measure(OM)1, OM2, OM3, OM4, OM5, OM6, OM7, OM8 LEVEL 2: Assessment, Follow-up1, FU2 > FU30 LEVEL 3: Self, Parent1 Parent2, Carer, Teacher, Other LEVEL 4: AgeGrp1, AgeGrp2, AgeGrp3 ...so: for outcome measure 1 (L1) , at assessment (L2), for parent one (L3) who completes the AgeGrp1 (L4) measure there are 50 flelds. Each age group has 50 (or so) fields (slightly different for each age group as might be e
  5. Sorry Comment - but you might have to explain that one in a little more detail for me... I mean, each time point will contain the 'same' 500 fields in related tables (time 1, time 2, etc) so that for one client the information gathered at time one is the same as that for time two (ie; follow-up data) - and I want to (say for client x) enter data into Time 2 (or other time points) by simply clicking on the time 2 tab (or other time point tabs - which contain fields from their respective time point tables) -. so please forgive me if I am being obtuse, but how does that relate to your 'indiviual
  6. Hi all - haven't been in for a while, but new job - convinced them FileMaker was the way to go; so a new database to build... I have a tabbed layout with a number of levels (each contained under a top structure of tabs - Time 1, Time 2, Time 3, etc) containing a total of nearly 500 fields at time 1 (and drawn from a Time 1 table). As mentioned I then have multiple time points (30 in all) that contain the same information (just the next time point along). To create the different time point fields I can (for example) duplicate the Time 1 table (and rename it to Time 2 - it does not mat
  7. OMG... (bemusement at own stupidity ) ...so it was. Thank you Vaughan.
  8. Usually, when I enter Layout Mode the whole screen (I have a widescreen display) has a white background with page and gridlines, etc displayed over the width (and depth) of the screen and I can utilse the whole of the screen to insert and manipulate fields/objects etc. However, on one particular dbase file, in L/O mode, the layout seems to restrict to just the parts and the rest of the screen background is blank grey - with no gridlines etc. Objects and fields do appear in this grey screen area (to the right of the L/O parts) but they cannot be dragged or dropped, only manipulated using t
  9. Final update: Master Table (Client demog. etc info, SRN) Program Table (linked to Master by SRN) Session table (Linked to Program table by SRN - shows date and type of all contacts made in a specific program and shown on Program Layout via a portal) Report table (linked to second instances of all Sessions tables via "x" - cartesian relationship) In Sessions table create all the totals variables needed. In my case each is conditional on a Month and Year and Activity type (of session) Activity_1_Duration (calculation) Case(Month = Report::Month_Select and Year = Report::Year
  10. ...stranger and stranger... If I affect a change in the sessions table...and then go back to the "precursor table (which has 0 records) and create a new record and then toggle the green "Found" button in the FMP toolbar... then the new record then reflects the changes made... Perhaps I will have to script this somehow... Delete the old > create the new > show the new... EDIT: interestingly, if I change the selection field before I delete the old, then I create new, then toggle the "Found" button, this seems to force the selection fields to operate properly back in the sessions
  11. Okay, I am part way there... From: http://fmforums.com/forum/showtopic.php?tid/213200/ I get: "Build a cartesian relationship from Table C to Table A using the "x" relationship which allows Table C to "see" all records in Table A." That works... (my "precursor" table now has a cartesian relation between all the different Program Session tables. This requires of course that another instance of each session table is created but I can then create a calculation field in the "precursor" that = the session field (Total_N_by_Month_and_Year or Total_Duration...) in the Session_2 (cartesian
  12. I am not sure if I can explain this well enough but here goes... I have a database where a number of clients are recorded in a Master table. Each client can participate in a number of different programs (for which a child Program table is created). Each client can then have a number of separate contacts with the company in each program, (which are recorded in a Sessions table via a portal in the Program Layout). Thus one client could for example have 10 sessions in Program A and 4 sessions in Program B (each on a different Date). Each session also records the Duration (mins) for
  13. I am not sure I understand your intentions here. I was talking about a NEW STANDARD layout containing just a Header and a Body (Layouts > New layout/Report > Standard Form... and follow the prompts...) and at the end delete the Footer and arrange the fields in a row in the Body - closing the Body up to show/contain just/only that row of fields - and place the field names into the Header just above the respective row of fields - editing them to plain English. Then assign Sort by functionality to the Header names. Resize the Header so you can add a title, navigation, function, etc as you w
  14. A bit more work, but... What about creating a new layout (a Header and a Body) with the required fields in a row in the Body (as in Table View) and the column names (as text boxes) in the Header directly above the fields. You can then assign sort by functions to each of the column names. The advantage of this is that you can also place navigation buttons, function buttons, Record number displays, etc in the header, giving you all the functionality of a Table View with added bonuses. I have done this and it works really well (users love it even more than the standard Table View). I also in
  15. Okayyy... I have now found the answer why! but not the solution... I ALSO had some self-join tables (Sessions 2, Sessions 3, etc) to enable the production of reports. I had related these tables by the field required in the reports (like "Location"). Because I had 3 self join tables, and each had a different field for the self-join relationship, this covered all the combinations in the original sessions table. I think what happened is when I deleted Portal Row, the relationships meant that everything "related" got deleted also... meaning ALL the records... (so Bruce ...you WERE precis
  • Create New...

Important Information

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