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

    Is this possible to do with FileMaker?



      Is this possible to do with FileMaker?


      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:


      ... 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":


      ... 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.