471,109 Members | 1,435 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,109 software developers and data experts.

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 1196

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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.