Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to get fields from foreign keys to appear in forms

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
I am currently doing a project for my A level and am not that familiar with Access. I have a member table which contains the foreign key "MemberTypeID" which contains fields fee per year and member type. How do i get these fields to appear in a form as well as the fields from the member table?
 
Create a query that links the two tables together on the MemberTypeID. Then simply add all the fields necessary for the report.

Base the report on the query.

Hope that helps.
Larry De Laruelle
larry1de@yahoo.com

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top