Using tbale field in Lookup Wizard

[dotancohen]

In a particular table I need to reference fields of that table to a Lookup Wizard in the same table. This is a genealogy database and there is a filed for parentMother and a field for parentFather, which should reference the unique key numbers of the proper entry, NULL is possible. However, the Lookup Wizard will not let me reference fields of the current table. I even tried writing a query on the ID and name fields, but the Lookup Wizard will not let me use a query that references the same table.

This is with Access 2007 on a Windows XP installation. I must stress that I am not a regular Access user, instead using Open Office Base on Kubuntu for my personal work.

[RuralGuy]

This link might be helpful.

[dotancohen]

Thanks, RuralGuy, that is my usage scenario right there!

[RuralGuy]

That's great! Do you want to follow the link in my sig and mark this thread as Solved?

[dotancohen]

Sure, thanks, I am not that familiar with vBulletin anymore. I had considered editing the original post to mark it but figured that there would be a more logical way.

Thanks!

[RuralGuy]

Thanks for the follow up.