By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,392 Members | 1,544 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,392 IT Pros & Developers. It's quick & easy.

Adding Data to a N:N relationship

P: n/a
Hi
I want to make a database for genealogy.
I have three tables persons, source and a third for joining them.
Persons Look like this: ID, LASTNAME, FIRSTNAME, DATE OF BIRTH
Source like this: ID, SOURCENUMBER, SOURCETEXT
The joining tables like this ID, PERSONS-ID, SOURCE-ID
Table Persons:Id is linked 1:N to Joining:persons-id and
Table Source:id is linked 1:N to Joining:sourcenumber

One person having many sources and one source relating to many persons.

I want a form showing: LASTNAME, FIRSTNAME, DATE OF BIRTH, SOURCENUMBER, SOURCETEXT
and being able to add data the without having to use the Joining table myself.
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.