Jump to content

bluedoor

Newbies
  • Content Count

    4
  • Joined

  • Last visited

Community Reputation

0 Neutral

About bluedoor

  • Rank
    newbie
  • Birthday 10/01/1953
  1. bluedoor

    3 file relationships

    Thanks Sam - I confess I'm still stuck. "A calculation field in B referencing C through a relationship would put the value you need in the portal in B": I already have a portal in B displaying values from C. Are you suggesting I replace this with a calculated field? If so, how do I get the multiple values? Hopefully - Paul
  2. bluedoor

    3 file relationships

    Hi all In a database describing processes, tasks and who does them (roles) I have several tables: A has a unique number for each task It also has a portal showing the individual or group role (which is stored in : B has the task unique number, and the stored value for the individual/group. When a new task is created in A, one record is created in B for each selected role. B also has a portal showing the 'actual role' which is stored in C. C has two relevant fields, and is the way in which the names of those individuals who make up the group can be revealed. The fields are Role/Group and Actual Role. When the individual is named in their own right, not as a member of a team, the values in these two fields are the same. There are multiple records in B for a given task. My problem is that when I report (in : wishing to display athe actual roles involved in each task, for groups it only displays the first actual role. I beleive that I need to create a new table, containing the Task UID and Actual Role (one record for each combination of Task UID and Actual Role) but I've been stuck on this for so long that I can no longer see how to do this, or how to populate it with the existing data (B contains 8500 reords, and some of the groups referenced contain over 10 members, so I don't want a manual process...) I know the answer is simple but I just can't see it. Paul
  3. Good question - it seemed like a good idea at the time! More seriously, it looked like a solution to the way the data is structured in the Access database it's coming from. I think I need to take a few steps back and go forward the relational way.
  4. Creating a smallish FMPro tool to do something Access can't (or not easily) I need to combine data from separate records into a repeating field. < Filemaker Techinfo article > ought to help but doesn't cos it refers to ScriptMaker functions in v2.x which are different in v5.0 (what I'm using). Specifically, "Reserialize", "Paste literal" (is this the same as "Insert text"? and the Lookup "DATABASENAME.FM=Copy contents of Index when Trigger matches a new entry in Trigger" (Index and Trigger being fields in the current database which is DATABASENAME.FM).
×

Important Information

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