OK, I got this running.
I used:
tb:Spouse1
WeddingID (AutoNumber)
PersonID (Number)
WeddingDate (Date/Time)
tb:Spouse2
WeddingID (AutoNumber)
PersonID (Number)
I used this with a form.
But i use a dropdown menu for the PersonID. Isn't there a way that i can use a dropdown menu for the...
I hope that you guys don't get sick of my questions :confused: . But I still can't get it right.
I tried:
tb:Wedding
WeddingID (AutoNumber)
SpouseID1 (Number)
SpouseID2 (Number)
WeddingDate (Date/Time)
But this way I cant get the relationsships right for the Querie.
Then i tried...
How to let ppl get married!! (part 2)
My database is like this now -->
tb:Address:
AddressID (AutoNumber)
Address (Text)
ZipCode (Text)
City (Text)
Phone (Text)
Country (Text)
tb:Person
PersonID (AutoNumber)
AddressID (Number)
FirstName (Text)
Insertion (Text)
Surname (Text)
Mobile (Text)...
My database is like this now -->
tb:Address:
AddressID (AutoNumber)
Address (Text)
ZipCode (Text)
City (Text)
Phone (Text)
Country (Text)
tb:Person
PersonID (AutoNumber)
AddressID (Number)
FirstName (Text)
Insertion (Text)
Surname (Text)
Mobile (Text)
EMail (Text)
DateOfBirth (Date/Time)...
With help off this forum I have succesfully created my first database :). I made a address / birthday database.
But now I want to show a wedding day between 2 ppl from the same table and column. Can anyone point me in the good direction how I can do this the best way?
My database is like this...