1 Reply Latest reply on Jul 6, 2010 9:49 AM by philmodjunk

    Golf Configuration - Question about count ?

    Rick77

      Title

      Golf Configuration - Question about count ?

      Post

      Hello,
      I create DB to manage the persons playing to golf.  I would like to know if we can create a view or something like that.
      I already enter some foursome in my DB.
      Then, I would like to know how many persons are in the particular foursome.
      So, the foursome 1A should show 3 contacts, 1B show 2 contacts and 3A should show 2 contacts
      I would like  to show only the Foursome used by DB.
      1A : 3
      1B:  2
      3A : 2

        • 1. Re: Golf Configuration - Question about count ?
          philmodjunk

          You can do this with three tables: GolfGames, Foursomes and Contacts.
          Relate them:

          GolfGame::GameID = Foursomes::GameID
          Contacts::ContactID = Foursomes::ContactID

          Place a portal to Foursomes on a GolfGame layout and you can use it to select players from Contacts to make a foursome. Place a portal to Foursomes on a Contacts layout and you can use it to see which games the current contact has been signed up for.

          On a GolfGame layout, you can add fields to this portal from Contacts to show name, phone etc for each member of the foursome.
          On a Contacts layout, you can add fields to this type of portal from GolfGame to show date, time, location etc.