Re: How to store Default choice.
If I´m note mistaken, u have this situation:
Originally posted by knife
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
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".
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