Alpha Video Training
Results 1 to 5 of 5

Thread: Creating Child Records

  1. #1
    Bob Flanagan
    Guest

    Default Creating Child Records

    I'm new to this, hope this is not a stupid question.

    I have a set with 3 levels (parent, child, grandchild).

    A form displays parent information and has an embedded browse for children.

    I put a button on the form that displays a form with child & grandchild information from the currently selected record in the embedded browse.

    This all works fine - here's my question:

    When I create a new record in the child/grandchild information (using the same set) it does not inherit the keys that link the child to the parent and the grandchild to the child. I would like to have the ParentID field automatically loaded in the new record (and would like to not allow anything else, actually).

    Any suggestions would be greatly appreciated.

  2. #2
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,310

    Default RE: Creating Child Records

    Bob,

    Perhaps the example posted in the Code Archive forum called "Pass values between forms" will help. -- tom

  3. #3
    "Certified" Alphaholic forskare's Avatar
    Real Name
    Ken Nordin
    Join Date
    Apr 2000
    Location
    Walker, MN
    Posts
    7,545

    Default RE: Creating Child Records

    Bob,

    Tom's suggestion is a good one because there are several possibilities. Mostly though, it depends on how the set is constructed as well as the form.

    Check out the creating sets and forms in the Getting Started book. Also there is a couple of examples in the code archive about basic data entry.

    kenn

  4. #4
    Bob Flanagan
    Guest

    Default RE: Creating Child Records

    Thanks Tom,

    That was exactly what I needed! Great example.

    Best regards,

    Bob Flanagan

  5. #5
    Bob Flanagan
    Guest

    Default RE: Creating Child Records

    Hi Ken,

    Thanks for the data. I'll do as you suggest. Meanwhile I've been going through the learning Xbasic tutorial.

    Best regards,

    Bob Flanagan

Similar Threads

  1. Creating a new record in a child table
    By lionel louviere in forum Alpha Five Version 5
    Replies: 4
    Last Post: 04-21-2004, 10:55 AM
  2. Need help creating script to add records
    By joannristau in forum Alpha Five Version 5
    Replies: 5
    Last Post: 10-01-2002, 11:37 AM
  3. Child Records
    By Steven Devaney in forum Alpha Five Version 4
    Replies: 5
    Last Post: 02-21-2002, 04:36 AM
  4. Creating Multiple Records
    By Sean Tucker in forum Alpha Five Version 4
    Replies: 2
    Last Post: 02-06-2002, 09:35 AM
  5. Child Records?
    By Bruce MacPherson in forum Alpha Five Version 4
    Replies: 2
    Last Post: 06-15-2000, 10:08 PM

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
  •