Alpha Video Training
Results 1 to 2 of 2

Thread: Posting Parent table fields to Child table

  1. #1
    Member Jimmie1234's Avatar
    Real Name
    Jim Stefancic
    Join Date
    Jun 2002
    Location
    Columbia, MD
    Posts
    99

    Default Posting Parent table fields to Child table

    I've got a set with 2 tables. Each has various fields:

    INV ID
    OHQTY
    ....etc.

    TRANS TID
    ID
    TRQTY
    TYPE
    ....etc.

    I would like to automatically append certain data that is entered into INV on an entry form to the TRANS table and set other fields in the TRANS table record to fixed values. The ID field is the linking field.

    The TID field in the TRANS table is an autoincrement field used for when I am only dealing with the TRANS table in other entry forms.

    For example, if I enter ONQTY for a selected ID item in INV, I would like a record to be appended in TRANS which has ID, OHQTY, and fixed data for other fields I choose. The TID autoincrement field needs to be updated so the next time I use only the TRANS table it is set at the correct value.

    Right now, I re-enter the data into both forms.

    Is this really as complex as I'm making it? Or can someone provide me a few hints on the easiest way to accomplish what I want.

    Jim

  2. #2
    "Certified" Alphaholic Scott Emerick's Avatar
    Real Name
    Scott Emerick
    Join Date
    Dec 2000
    Location
    Central Virginia/ North Carolina Border
    Posts
    2,154

    Default RE: Posting Parent table fields to Child table

    Jim,

    Check out action scripting -> Fields -> set field values

    I believe this is what your looking for.

    Good luck

Similar Threads

  1. Linking a Parent table to child using expression
    By Susan Schlueter in forum Alpha Five Version 6
    Replies: 2
    Last Post: 04-25-2005, 01:49 PM
  2. Parent table based on query of child table.
    By edward.mattison@scbhn.org in forum Alpha Five Version 5
    Replies: 1
    Last Post: 02-25-2005, 04:14 PM
  3. Child Record Fields Default from Parent Fields
    By wwolfe in forum Alpha Five Version 5
    Replies: 9
    Last Post: 11-05-2004, 10:13 AM
  4. Still stuck with child/parent posting issues...
    By ThomG in forum Alpha Five Version 5
    Replies: 3
    Last Post: 05-18-2004, 04:03 AM
  5. Posting to a child table
    By ARNOLD KRAMER in forum Alpha Five Version 5
    Replies: 1
    Last Post: 11-24-2002, 04:41 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
  •