Monday, 26 August 2013

Creating table derive from the fields

Creating table derive from the fields

can I ask if its possible to create table that derived from the data you
have input.
example you have column FullName then it has 'Juan dela Cruz'. Next, I
want the 'Juan dela Cruz' become a table and this table have columns like
Attendance, Time In, time Out, Violations.
This is i want to state:
technicianTBL
+----+----------------------+
| ID | Fullname |
+----+----------------------+
| 1 | Juan dela Cruz |
+----+----------------------+
will become:
JuandelacruzTBL
+------------+----------+------------+
| Date | Time In | Time Out |
+------------+----------+------------+
| 01/01/2013 | 7:00am | 5:00pm |
+------------+----------+------------+

No comments:

Post a Comment