HI,

I am creating a form for entering registration details into a record with
fields like regno, name, address, etc. When I enter one field called
referral id, i d like the name from the record of that id from the same
table be displayed in this form. How do i do this? How can i setup a query
such that the name from another record in the same table in used.

Thanks for any help.
Ramesh

Ramesh,

The short answer to this is that it may be worthwhile to review your
table design. If a particular name and address are associated with a
specific referral id, then this probably should be stored in a Referrals
table or some such, and then the data you are entering via this form
should be a separate table, related one-to-many, with only the referral
id, and the name referenced from the "one" side table. Hope you
understand what I mean.

This is an article on a related topic which may be of interest:
http://accesstips.datamanagementsolu...biz/lookup.htm

--
Steve Schapel, Microsoft Access MVP

Ramesh wrote:
> HI,
>
> I am creating a form for entering registration details into a record with
> fields like regno, name, address, etc. When I enter one field called
> referral id, i d like the name from the record of that id from the same
> table be displayed in this form. How do i do this? How can i setup a query
> such that the name from another record in the same table in used.
>
> Thanks for any help.
> Ramesh
>
>