Hi guy need some advise on how to create the a tracking system for the badge id for the company. It need to show a the data grid on the previous user and current use detail and show which is active or not. Can anyone give some ideas on it. Just tell me what you understand and know i need to gather idea. If it is you how you will do about it ??

Table structure...
tblBadge
iBadgeID AutoNumber
iEmpID Number Foreign Key
dTimeIn date/time
dTimeOut date/time

tblEmployee
iEmpID AutoNumber
vFName text (25)
vMI text(1) Optional allow blanks/nulls
vLName text(25)


Then, see my reply in this thread post #4
http://www.daniweb.com/forums/thread181952.html


Good Luck