Hi folks.

I have the following tables (PK = primary key, FK = foreign key):
Member (MemNo [PK], MemName, MemType, Course/Faculty)
History (..., MemNo [FK], ...)

Member and History are linked in a 1 (Member) to Many (History)
relationship.
I have a form (frmHistory) based on a query (qryHistory) which is
based on these tables.

When I type in a number in the MemNo field in frmHistory, the fields
MemName, MemType, and Course/Faculty automatically fills up
(coressponding to the data in Member). I would like to fill up these
fields by typing in MemName instead. How do I do this? (BTW, I'm using
Access 97)