Dear Richard, I try to populate attendance Table T1 in the same raws (Record) with value Max(CheckIn) from T2 and Max(CheckOut) from T3 . However T2, T3 content multiple record with same ID and Date, because some times the employee check in twice on device. For Infos, Table T1(Id, Name, Date, CheckIn, CheckOut) ; T2(Id, Date, CheckIn) ; T3(Id, Date, CheckOut). Is there a way to do that. Thanks
Kevin Robertson
@Reply 3 years ago
Why are you storing the same data in multiple tables?
Too Many Tables
Name and Date are reserved words and should not be used as field names.
Reserved Words
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
