Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Oct 2002
    Location
    Leamington Spa, Warwickshire, England
    Posts
    136
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Creating a Database (2003)

    I want to create a TNA database based on 7 subjects. Ideally I would like the learner to be able to enter their details then complete a questionnaire form.

    It will work using subreports but this looks messy unless you know what you are doing and I won't be standing over then to check. also I don't want them to be able to see other people details.

    Will a relationship work if in one table is autonumber and the related table is number?

    Thanks

    Michelle

  2. #2
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating a Database (2003)

    Yes the relationship will work as long as the related field with the number datatype is long integer
    Carla

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Creating a Database (2003)

    Actually, that's the only way it will work. There isn't really any way to relate two autonumbers because there is no way to keep them in sync.
    Charlotte

Posting Permissions

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