How to goto last record in 2nd table?

[Guest]

Table dbo_case (case_no is PK) link 1-to-many to table dbo_Lic (case_no is FK)

SELECT DBO_case.case_no, DBO_case.id, DBO_case.lname,
DBO_case.fname,DBO_Lic.Lic_no, DBO_Lic.Lic_date INTO TBLViewRecord1
FROM DBO_case INNER JOIN DBO_LicON DBO_case.case_no = DBO_Lic.case_no
WHERE (DBO_case.case_no=[Form]![FrmViewSearch].[CaseNoBox]);
How can I select the last record in the table dbo_lic?
Thank for any advice,
MN

 

[Guest]

SELECT DBO_case.case_no, DBO_case.id, DBO_case.lname,
DBO_case.fname, Last(DBO_Lic.Lic_no) AS LastLic, DBO_Lic.Lic_date INTO
TBLViewRecord1
FROM DBO_case INNER JOIN DBO_LicON DBO_case.case_no = DBO_Lic.case_no
WHERE (DBO_case.case_no=[Form]![FrmViewSearch].[CaseNoBox]);