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

Using same table for Lookup

P: n/a
Hello all,

I've tried to work this one out myself, but appearantly my brain is
just a little wacked right now and I need some feedback.

I'm trying to design a genealogy database (mainly because most
databases out there don't do what I want them to). I'm creating what
is essentially a "People" table. In this People table I need to have
three fields which look up other names from within the same table:
Father, Mother, and Spouse. Every single record, theoretically, should
have each of these fields (though sometimes we don't know WHO that
person is) except maybe for Spouse.

I can generate a list of children from the Father & Mother so I don't
need to specifiy children or have a children's table.

How do I create a lookup from the same table in the same table? My
thought was to create a query of the table with the specs (for example
a "Father Query" would look up all the existing "Male" records in the
table) and then use that for my lookup, but that isn't working.

So how do I get this to work?

Any suggestions would be greatly appreciated.

Tammy, the very tired puppy (*yawn*)

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies

P: n/a
Save yourself at least some of the pain. Read Allen's article

Nov 13 '05 #2

P: n/a
Thank you immensely!!!


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.