AnsweredAssumed Answered

Is this possible to do with FileMaker?

Question asked by SB on Jun 10, 2011
Latest reply on Jun 12, 2011 by 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.

Outcomes