Using DLOOKUP with tables only

[Access_Novice]

In the attached Word document I have a screen shot showing the fields for the "Membership" table and "Class table." I am working exclusively with tables, no forms.



In the Membership table, I will enter a numeric value in the Class field. In the Tuition field, I want to use a DLOOKUP, which would look to the class column next to it, take that value as a lookup number, then go to the Class table (second screen shot) and locate that lookup number in the ClassID field, find the corresponding value in the Tuition column, then drop that result in the tuition field of the membership table.

Example:

In the Membership table, I enter 7 in the Class field. The tuition field should automatically return $160, because in the Class table, the classID 7 corresponds to a price of $160.

I tried setting up the Tuition field in the membership table as a calculated field, then I entered a DLOOKUP in the expression box and received an error.

Is it possible to do this type of Lookup?

[ItsMe]

I can honestly say I have never tried that before.

[ssanfu]

I am working exclusively with tables, no forms.

This is a VERY bad practice.

Even if the dB is only for you, you should ALWAYS use forms to interact with data.

IMO, using calculated fields is also a bad practice. I never use calculated fields.

[June7]

Can't use functions in Calculated type field in table anyway. Use query as basis for forms and reports.

[Access_Novice]

I can honestly say I have never tried that before.

Thank for your input sir.