4 Replies Latest reply on Jun 12, 2011 3:11 AM by SB

    Is this possible to do with FileMaker?

    SB

      Title

      Is this possible to do with FileMaker?

      Post

      Hi, I want to use FileMaker for a larger database project and I need  several more complex table layouts in that so I'm wondering if it's  possible to do the following with FM (and if yes, how to do it) ...

      Having a table that contains records that are used as fields in another table, for example:

      Table 1 named "skills" with fields:

      skillID
      skillName
      skillCategory

      ... this table will have several 'skill' records with their ID, name, etc.

      Now in another table I'd like to use the records of the skill table AS fields:

      Table 2 named "characters":

      characterID
      characterName
      characterSkills

      ... in this table the characterSkills field should  be a Portal component that lists all the entries from the skills table  with their skillName and for every of the skills a value can be assigned  for the character.

      Makes sense? I know how to add a Portal that  shows the fieldnames of another table but I can't figure out how to make  a portal where you are able to use the record's values as fields in  another table.