make table query problem

[ijaz1976]

hello everyone!
i m new to access i m trying to create a table to save records permanently with make table query.
table structure is:
-------------
tbl_admissions:
studentID
studentName
fathername
etc
---------------
tbl_classes:
classID
classname
monthlyfee
etc
---------------
tbl_feevoucher:
ReceiptNo
studentname (from tbl_admissions through lookup)
class (from tbl_classes through lookup)
etc
when i run make table query, in created table i get studentID instead of studentname and classID instead of classname but i want names instead of numeric fields how to troubleshoot that problem.
database sample is attached.
any help would be highly appreciated and thanks in advance.

 

[Mr. B]

First, there is no "make table" type query in your attached database.

Next, you cannot use a reference to another table and field as the criteria for a query as you have in a couple of your existing queries.

 

[ijaz1976]

sorry for uploading without append query but can u create one for demonstration
thanks in advance