anyway I can use dlookup in access 2k from the table design view ?

[Van T. Dinh]

You Tables store redundant data!

Assume ReportID is the Field you use as the Primary Key in
Table1, then you shouldn't need to store ReportName in
Table2 since by knowing the ReportID, you ALREADY know the
ReportName from data stored in Table1.

Also, data entry should be done on Form, NOT DatasheetView
of Tables.

There is a Lookup Field Type in the Table DesignView but
I don't recommend it as it will confuse you more.

I suggest the first step is to freshen up your knowledge
on Relational Database Design Theory and see if you can re-
design your Table structure.

HTH
Van T. Dinh
MVP (Access)