team members

[Raymond Gonzalez]

hello! i have two tables. one "members" and the other "team". in "members" i have the info about hte member and an "id" in the "team" i only have the "id" and the "team name". I want in the layout of the members, to show the "team name" of that member and all the members that are part of that team. How can i do that?! thanks! and sorry for being such a newbie!

[CobaltSky]

To show the name of the team, simply place the team name field (from the team table occurrence) onto the members layout - it will display the related information for the current member. To choose which table occurrence you are selecting a field from when adding it to a layout, use the pull-down menu at the top of the "Specify Field" list dialog.

To show a list of the members of the team, you will need a second table occurrence of the members table (linked to the first based on teamID - called something like "TeamMates") and a portal attached to the second table occurrence and with the member name field/s appearing in it. Portals are created using the list iccon in the status area in layout mode.

If you want the portal to include all the team members *except* the current member then you'll need a unique ID in the member table (eg a serial number) and you'll then be able to define the relationship between the Members and TeamMates table occurrences as:

TeamID = TeamID

AND

MemberID ≠ MemberID

:D

[Raymond Gonzalez]

hello! sorry! i dont know if i really understood. I have to make a 3rd table? im trying to do it and for some reason it doesnt work

[Raymond Gonzalez]

anybody can help? plz!!!

[Lee Smith]

Open FileMaker, Click on the Help in the Menu, and then type in this:

Defining database tables

HTH

Lee