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

    Unanswered: Storing of default values


    To my database of personal informations I'd like to add the ability to have multiple emails stored with one being default. I have solved the multiple with a one-many relationship but the default is still unsolved.
    Just like in the adressbook in Outlook-express.

    Usually everyone has a "default" email for contact among the personal, work etc related emails. Same applies to people with multiple street adresses, home,work,summer etc.

    How default values usually solved in a easy and robust way (enforce referential integrity)?


  2. #2
    Join Date
    Sep 2003
    You could just have a separate default data table with a column to include email. This way if the email on your form or whatever is null, you can p/u the default with a dlookup.
    All code ADO/ADOX unless otherwise specified.

Posting Permissions

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