468,719 Members | 1,761 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,719 developers. It's quick & easy.

automatically filling up fields

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)
Nov 12 '05 #1
0 1126

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by hboothe_no_spam | last post: by
3 posts views Thread by crjunk | last post: by
1 post views Thread by CARIGAR | last post: by
1 post views Thread by Oskars | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.