Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Raleigh, NC
    Posts
    183

    Red face Unanswered: Main Form with 2 subset of Subform

    I have one main form with three subform. My 1st subform is link to the main form and 2nd subform is link to the 1st subform and 3rd subform link to the 2nd subform.

    Problem is that when i don't enter any value in 2nd subform i'm still able to input value in 3rd subform and it still saves in table. (1 to M)

    For example 2nd subform holds data about Customer and 3rd subform holds data about customer order. Even know there is no customer i can still input the Order information. How can i validate this ?

    Thanks in advance
    Skharva

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    One solution would be to make sure the 3rd form is linked to more than one record in the 2nd form one of which is unique to that form. If 1st and 2nd are not linked using customerID then you can use that as a link between 2nd and 3rd

Posting Permissions

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