Automatically populating a table field based on a LOOKUP value?

[Access_Novice]

I have two tables, "Membership" and "Class." The Class table has a class ID, class name, and cost of the class.



In the Membership table, I have a field to accept a class ID that is entered by a user. I also have a column called Tuition. When the user enters a classID in the Membership table, I would like the dollar amount associated with that classID to automatically appear in the field called Tuition in the Membership table.

I tried the LOOKUP data type and calculated fields, but no luck. I know that DLOOKUP can be used on forms, but I don't see how it can be used directly with tables.

Is this even possible?

[June7]

Code is required to save calculated value to table. Cannot be done in table, except maybe with Data Macro. I don't know much about Data Macros. I use only VBA and don't do data entry directly with tables.

Are you saving tuition in Membership because of possibility tuition for the class could change in the future?