Alpha Video Training
Results 1 to 10 of 10

Thread: Need Data Entry Advice

  1. #1
    Member
    Real Name
    Bob M
    Join Date
    Dec 2001
    Posts
    562

    Default Need Data Entry Advice

    Pretty sure this is going to be a Beginner's Question, but it is driving me crazy.

    Is there a process, using Action Scripting, for getting a parent/child link common field into the child table?

    My primary table contains a Contact_Id field and a variety of child tables are linked with this same titled/length field in the child tables.

    I have been using lookup tables for the most part but now, I have a browse in a child link where that doesn't seem to be practical. I can use this process but am now curious if there is a more practical method I can incorporate using Action Scripting.

    Thanks in advance

  2. #2
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,573

    Default Re: Need Data Entry Advice

    or use a set to enter data and have the linkage automagically filled in.
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  3. #3
    Member
    Real Name
    Bob M
    Join Date
    Dec 2001
    Posts
    562

    Default Re: Need Data Entry Advice

    Thanks Al.

    I must be doing something wrong in setting up my sets because they do not automatically fill. And I did think they automatically filled but not happening.

    The attached images are my typical setup (sorry for landscape look but only way I can capture the screen).
    Attached Images Attached Images

  4. #4
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,573

    Default Re: Need Data Entry Advice

    I'm wondering if you are expected the contact information (name,address,something else) to be duplicated in the child tables even though the linkage from the child to the parent works.

    Can you show the fields from each table that you expect to fill from parent to child?
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  5. #5
    "Certified" Alphaholic
    Real Name
    John Koh
    Join Date
    Jan 2004
    Location
    Maryland, USA
    Posts
    1,066

    Default Re: Need Data Entry Advice

    Bod,

    Did you know you can make smaller the " Set Editor"
    Attached Images Attached Images

  6. #6
    Member
    Real Name
    Bob M
    Join Date
    Dec 2001
    Posts
    562

    Default Re: Need Data Entry Advice

    Quote Originally Posted by Al Buchholz View Post
    I'm wondering if you are expected the contact information (name,address,something else) to be duplicated in the child tables even though the linkage from the child to the parent works.

    Can you show the fields from each table that you expect to fill from parent to child?

    Al, the only field I am trying to fill is the child table Contact_ID. I am only trying to tie the child table to the parent table for relating info on a form.

    To coin an old phrase, "son of a biscuit eater". I just tested with the change of enforcing referential integrity and it seems to work. I was not enforcing based on earlier advice on a different question.

  7. #7
    Member
    Real Name
    Bob M
    Join Date
    Dec 2001
    Posts
    562

    Default Re: Need Data Entry Advice

    Quote Originally Posted by johnkoh View Post
    Bod,

    Did you know you can make smaller the " Set Editor"
    Thanks John

    No, I was not aware of that. Good advice for future image sharing.

  8. #8
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,573

    Default Re: Need Data Entry Advice

    Bob

    Your contactid should be entered without referential integrity.

    Remove the referential integrity and duplicate the set to a new name with all the objects of the set.

    Then drop the original set from the database.

    Duplicating is magic at resolving internal issues of sets and tables with field rules.

    Referential integrity should be avoided due to it's high cost vs benefit.
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  9. #9
    Member
    Real Name
    Bob M
    Join Date
    Dec 2001
    Posts
    562

    Default Re: Need Data Entry Advice

    Will give it a try Al

    Is the high cost speed?

  10. #10
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,573

    Default Re: Need Data Entry Advice

    Quote Originally Posted by Mortie View Post
    Will give it a try Al

    Is the high cost speed?
    Not so much speed as multi user locking conflicts and a 256 limit on the number of child records for each parent.
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

Similar Threads

  1. UX Data Source Design Advice
    By josephmoeller in forum Mobile & Browser Applications
    Replies: 0
    Last Post: 12-16-2014, 04:32 PM
  2. Advice on validating data in a Table
    By Paul Main in forum Alpha Five Version 6
    Replies: 7
    Last Post: 11-09-2006, 06:56 PM
  3. data entry: Argument is incorrect data type
    By ten10ten in forum Alpha Five Version 4
    Replies: 6
    Last Post: 05-18-2006, 01:57 PM
  4. Advice needed on transferring data from flat db
    By Charlain in forum Alpha Five Version 5
    Replies: 2
    Last Post: 05-30-2003, 06:12 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
  •