Probably being really thick here, but here goes:
I'm trying to create a field that looks up the key field of the table that it is in (ie so that the table references itself). However, when I work my way through the lookup wizard in the table design view, I am only invited to select fields from other tables in my database.
Does anybody know how I can look up fields from the same table?
Thanks in advance for any help you can offer,
Jamie
I'm trying to create a field that looks up the key field of the table that it is in (ie so that the table references itself). However, when I work my way through the lookup wizard in the table design view, I am only invited to select fields from other tables in my database.
Does anybody know how I can look up fields from the same table?
Thanks in advance for any help you can offer,
Jamie