Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Location
    Maryland
    Posts
    152

    Unanswered: problem with master detail form

    hi,
    I have a frmMaster, frmDetail and fromDetailChild. I created form with subform concept i.e. Master-->Detail-->DetailChild.
    Q1. Is necessary to add primary key a table to b and then b table's primary key to c. If i do that it showes same field on three different locations in the form
    Q2. For example if I show that fields, how do I hide them . i used .visible=false. It is not working.
    Q3. If I don't add primary key fields in sub forms, it works fine with Master-->Detail but when it tries to save in Detail-->DetailChild, it raises error that primary key can't be null.

    Please help me , I am stuck since morning
    mr_roomi

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    What is the relationship between master, detail, and detail child?

    It sounds like detail child is directly related to master, instead of being directly related to detail. That could be a problem..

  3. #3
    Join Date
    Mar 2004
    Location
    Maryland
    Posts
    152

    no master is linked with detail and detail is linked with detailchild

    hi,
    no master is linked with detail and detail is linked with detailchild.

    can any one help me


    Originally posted by Teddy
    What is the relationship between master, detail, and detail child?

    It sounds like detail child is directly related to master, instead of being directly related to detail. That could be a problem..
    mr_roomi

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1

    Re: no master is linked with detail and detail is linked with detailchild

    Originally posted by Mr_roomi
    hi,
    no master is linked with detail and detail is linked with detailchild.

    can any one help me
    My question is regarding this point:

    Q1. Is necessary to add primary key a table to b and then b table's primary key to c. If i do that it showes same field on three different locations in the form
    If A is linked to B, and B is linked to C, how is it that a field from A appears on C as a key? That's not right.

Posting Permissions

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