Results 1 to 4 of 4

Thread: Simple 1 to many record/table creation

  1. #1
    restorick is offline Sugar Community Member
    Join Date
    Dec 2007
    Location
    Milwaukee, WI
    Posts
    15

    Default Simple 1 to many record/table creation

    Folks,

    Apologies if this has been covered before, but I'm curious as to what is involved in creating a simple 1 to many table relationship to the Accounts record? I'm using CE 5.2.

    I would also need to build a data entry and edit form at the record level.

    Appreciate any pointers. Thanks in advance.

    Rick

  2. #2
    mvngti is offline Sugar Community Member
    Join Date
    Oct 2007
    Location
    South Africa
    Posts
    510

    Default Re: Simple 1 to many record/table creation

    In 5.2 this is very easy.

    Go to Studio -> Accounts -> Relationships and add a relationship.
    Select one2many and the module on the other side of the relationship and save.

    It will create the relationship for you and add the subpanels to the modules.

    M
    --


    Marnus van Niekerk

    There are only 10 types of people in the world
    those who can read binary and those who don't

    Modules:
    CE Teams - Upgrade safe teams module for Community Edition
    FieldACL - Field Level Access Control for Community Edition
    EditLogicHooks - Create and edit Logic Hooks from the Admin GUI
    FlexibleChartDashlet - Display any data in a Dashlet Chart
    DocumentThumbnails - Thumbnails for Documents module

    Many questions can be answered by reading the Developers Manual

  3. #3
    restorick is offline Sugar Community Member
    Join Date
    Dec 2007
    Location
    Milwaukee, WI
    Posts
    15

    Default Re: Simple 1 to many record/table creation

    Marnus,

    Thank you for the quick reply. I was able to locate that on my own (after I had another cup of coffee...)

    Thanks again!
    Rick

  4. #4
    mvngti is offline Sugar Community Member
    Join Date
    Oct 2007
    Location
    South Africa
    Posts
    510

    Default Re: Simple 1 to many record/table creation

    I once interviewed a programmer but after he told me he does not drink coffee.... :-)

    M
    --


    Marnus van Niekerk

    There are only 10 types of people in the world
    those who can read binary and those who don't

    Modules:
    CE Teams - Upgrade safe teams module for Community Edition
    FieldACL - Field Level Access Control for Community Edition
    EditLogicHooks - Create and edit Logic Hooks from the Admin GUI
    FlexibleChartDashlet - Display any data in a Dashlet Chart
    DocumentThumbnails - Thumbnails for Documents module

    Many questions can be answered by reading the Developers Manual

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. MySQL Error 1062 on creation of record
    By monsta in forum Help
    Replies: 9
    Last Post: 2007-10-01, 08:50 AM
  2. Replies: 1
    Last Post: 2006-06-11, 01:09 AM
  3. Auto Table Creation
    By indy in forum Help
    Replies: 3
    Last Post: 2006-05-27, 08:32 PM
  4. hanging during table creation....
    By rhytha in forum General Discussion
    Replies: 2
    Last Post: 2006-01-17, 02:19 PM
  5. Unable to import very simple contact record
    By extremesanity in forum Help
    Replies: 1
    Last Post: 2005-04-12, 12:30 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •