Results 1 to 2 of 2

Thread: Try this

  1. #1
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Unanswered: Try this

    tblSchools should have a
    SchoolID field (autonumber primary key)

    in tblContracts a field
    SchoolIDLink type number

    if using a form to enter contracts the form record source would be tblSchools add a subform with record source tblContracts
    use SchoolID > SchoolIDLink being the relationship

    Set this up in relationships too...

    Hope this is detailed enough

  2. #2
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665

    Re: Try this

    Originally posted by garethdart
    tblSchools should have a
    SchoolID field (autonumber primary key)

    in tblContracts a field
    SchoolIDLink type number

    if using a form to enter contracts the form record source would be tblSchools add a subform with record source tblContracts
    use SchoolID > SchoolIDLink being the relationship

    Set this up in relationships too...

    Hope this is detailed enough
    Not sure I understand the question
    Jim

Posting Permissions

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