I am making a data base of employe daily Roll call system base.
But i am facing some problem.That is explain below.


There is a table of employe.
field discription.

Imploy_ID, Employ_name,Field_type

now i create an other table (Name dailycalling) for daily calling purpose

Imploy_ID,Employ_name,Todaydate,absent_present(By lookup wizard absent,present)

Now i make create relation ship employe table to dailycalling table between the field

Imploy_ID to Imploy_ID.

now i make a query by using both table field to add data that i used are as follow.

Imploy_ID, Employ_name,Field_type.

Now tell me how i can create a table in which employe id and name apearly daily automatcally
and also apear current date,As soon employ come in office i just make it Roll call.
absent or present.