FiveTech Support Forums

Silvio.Falconi wrote:I must create a small archive to check the presences of employes
times of attendance are inserted manually and not with the help of electonic readers
I created a database with fields for the 5 characters such as entrances and exits sample "08:00" - "14: 00"
my problem is that although I create 5 input groups and output I am afraid that not enough
How can I fix the problem?
I wish also check the tollerance of entrance and the exits .how I must make ?

Podrias acalara cual es el miedo que tienes.? ya que mi ingles no es muy bueno y el traductor no aclara a que es lo que le temes en lo que haces y a que te refieres con que creas 5 grupos de entradas-salidas, son valores prefeterminados o son para compararlos con la hora de entrada-salida.? si puedes colocal tambien tu pregunta en español para entenderte un poco mejor, saludos, gracias...

Sivio:

Puedes crear un archivo con los siguientes campos

Número de empleado
Fecha
Hora de llegada
Hora de salida

Un registro por cada entrada y/o salida, así no tienes límites.

Ejemplos:
1245 2016/11/17 08:00 00:00
1245 2016/11/17 00:00 14:10
1245 2016/11/17 15:15 00:00
1245 2016/11/17 19:00

1245 2016/1118 07:50 00:00

Saludos

As Armando has shown you need a one-to-many database relationship.

For more information on database design (including one-to-many) see this link:

http://www.ntu.edu.sg/home/ehchua/progr ... esign.html

Regards,
James

please I not Problem with one to many dbf...

I made 4 group of IN and OUT
E1 U1
E2 U2
E3 U3
E4 U4
generally I use the first for the morning turn and the third for the afternoon turn

but now I saw employes go in and go out many times at morning and on afternoon - the 4 groups are not enough
I thinked to create another dbf with only these fileds

Emplo_number 4 cr
day 8 d
E 5 cr
U 5cr
activity 5cr

and then call all to my elaboration calc

but I wanted to put all the entry and exit for that specific day in a table xbrowse
sample:
this is now the table :
-----------------------------------------------------------------------------------------------------------------
DAY E1 U2 E2 U2 E3 U3 E4 U4
---------------------------------------------------------------------------------------------------------------
4.11.13 || 08:00 |14:00 | | 00:00 |00:00 | | 15:00 |18:00 | | 00:00 |00:00 |
-------------------------------------------------------------------------------------------------------------------

with the new archive I must insert all time stamping on a text field because because the xbrowse does not allow the inclusion of other dbf inside a table column instead of Access .I saw this in an application made with vbasic and access

please see it

where I see 8 groups but on the bottom I see horizontal scroll of the column

please see the 13.01 day the emplyer have many times stamping

I f I create 8 groups instead my 4 I'm afraid it not enough....