January 4, 200719 yr 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!
January 4, 200719 yr 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
January 4, 200719 yr Author 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
January 11, 200719 yr Open FileMaker, Click on the Help in the Menu, and then type in this: Defining database tables HTH Lee
Create an account or sign in to comment