Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    4

    Question Unanswered: How to store Default choice.

    Hi again,

    As I did not get any answers from my last post I try to reformulate it.
    The situation is as follows:
    1 table with personal information, nameID as primary key
    1 table with all the persons email adresses, field names are
    - emailID, primary
    - nameID
    - emailadress
    - note
    These two tables are linked with one-many.

    Somewhere I'd like to store each persons preffered email (his default), each person can hold max one preffered email.

    Any idees how to solve this.
    Even better if it can be solved with "Enforced Referential Integrity".

    Regards
    Joakim Jonsson

  2. #2
    Join Date
    Oct 2003
    Location
    So Paulo - Brazil
    Posts
    91

    Re: How to store Default choice.

    Originally posted by knife
    Hi again,

    As I did not get any answers from my last post I try to reformulate it.
    The situation is as follows:
    1 table with personal information, nameID as primary key
    1 table with all the persons email adresses, field names are
    - emailID, primary
    - nameID
    - emailadress
    - note
    These two tables are linked with one-many.

    Somewhere I'd like to store each persons preffered email (his default), each person can hold max one preffered email.

    Any idees how to solve this.
    Even better if it can be solved with "Enforced Referential Integrity".

    Regards
    Joakim Jonsson
    If Im note mistaken, u have this situation:

    Personal Emails
    Information <----------->> Adresses (1:N)


    Create a field in Personal Information that will store the emailID of the default e-mail.


    I u have any trouble, contact me.
    My environment: Windows XP/ Access 2000 - Using Microsoft DAO 3.6 Library

Posting Permissions

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