Insert data into table

[MikiA]

Hello,

I have fields on the form as in the picture.
There can be over a hundred different people.
Second text box was date of creating entry.
It is set to the default value of current day for every
time i open the form.
Third and fourth text box is for numeric values.
I bound text boxes to the table field.
Set form to the data entry YES.
So, when i open form and make entry at the first text
box i got same values at all text boxes at the form.


I believe this is because the text box is linked to the same field in the table.
I mean workink hours to the field 1, extra hours to the field 2....
Behind the name is a hidden text box with id values ​​for the given name.


Does anyone have any idea how to do this?
Should I set the fields to unbound and use the sql statement to enter data into the table?

[Bob Fitz]

I'm not sure what the problem is with your form but posting a copy of the db would help with that.

[MikiA]

I just stated and stuck with this. I use access button for adding records at the form. I upload sample database, so maybe will be understable wht i try to do.

[Bob Fitz]

I'm afraid your db makes no sense to me. You have NO relationships defined.
I don't understand the language, of course, but on the form you appear to have the names of people in Label controls.

IMHO from what I have seen, I would recommend you to read up on database design and normalization.

[orange]

I agree with Bob. I don't understand your database nor its intended usage. Since it's in foreign language (possibly Croatian??), I don't think many members will readily understand it either. I recommend you provide a brief description in non-database terms of what "processes" this database is intended to support. Further, I recommend that you write it in your native language; then translate to English (Google translate) and post.
Good luck.

Nadalje, preporučujem da ga napišete na svom materinjem jeziku; zatim prevedite na engleski (Google translate) i objavite.
Sretno.

[Gicu]

Please have a look and see if that is what you were trying to achieve.

Cheers,
Vlad