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 ??
gingank 0 Junior Poster
vb5prgrmr 143 Posting Virtuoso
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
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.