Parent Child data projects

  • Resolved larryhines

    (@larryhines)


    5 years, 12 months ago

    I have successfully created a data project using the parent child relationship functionality. I have complete control over the parent table (limiting views, editing label names and using lookups. I would like to do those things for the child table also, but cannot figure out how.

    It seems I get the whole child table with column labels.

    Here are some more specifics.

    1. The parent table is a list of events with dates.
    2. Person selects an event to open the Child table to register for the event.
    3. Person enters their name (lookup if possible) and indicates Yes/No if they want to participate.

    The Child table has additional columns that will be used later in my process which I do not want to display at this time. I only want the persons name from a lookup and the YES/NO column.

    The Person registering is from a table containing names thus the desire for a lookup. You must be included in that table to be able to register.

    What am I missing? Let me and I can send screenshots if necessary.

    I love your plug in. Look forward to the PRO version.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    5 years, 12 months ago

    Hi Lawrence,

    To configure a child table you need to create an option set:
    – Go to Data Projects
    – Click on tab Manage Table Options
    – Click on button Add Table To Repository
    – Select your child table
    – Click on button Add Selected Table To Repository

    Your child table structure will be loaded into the plugin repository. Ones loaded, make sure the name of your option set is equal to the name of the option set which you have defined for your project page (default option set name = default). The plugin uses one option set name for each project page (parent and child table(s)). Within your option set you can select which columns you want to be shown on your list table as well as your data entry form. Working with option sets is explained in this video:
    https://wpdataaccess.com/docs/documentation/data-projects/manage-table-options/

    If you want to use your child table on multiple project pages, you have to create multiple option sets. This allows you to show different columns on different pages. Using multiple option sets is explained in this video:
    https://wpdataaccess.com/docs/documentation/data-projects/table-options-advanced/

    Please check out the videos. I think they can be very helpful in getting this to work.

    Thanks for your compliment! 🙂

    Best regards,
    Peter

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    5 years, 11 months ago

    Hi Lawrence,

    Are you making progress? Do you need help? Can I close this topic?

    Thanks,
    Peter

    Thread Starter larryhines

    (@larryhines)

    5 years, 11 months ago

    Yes, I am finally making progress. I have a project con figured with parent child table. Thanks. I will close this out. I have more questions, but will open a new topic for those. Thanks for the help.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Parent Child data projects’ is closed to new replies.