Displaying name from diff record

[Ramesh]

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

 

[Steve Schapel]

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.datamanagementsolutions.biz/lookup.htm