Problem with data entry

[Marcellllo]

Hi guys

I ve just finished model of DB and it looks like this ( )

Now I would like to insert some data into database though form, but if I for example add New contractor ( first name, last name ) with his location , it doesnt connect in table User-Location ... so it is not matched ... can someone help me how to set a form to avoid this problem ?

Thanx a lot

 

[rzw0wr]

Your tables look ok,
Your relationships on some look backwards.
A few examples are;
tbl_Location. You can have only one location per user. You can not enter a user without first entering a location. Put the user_ID in the Location table.
Same with tbl_Years Of Experience, tbl_Area of Experience.
Look your relationships over.
FYI, Remove ALL space and special characters ( Other than underscore) from ALL names. You will thank yourself later.

TIP:
IF, AN ENTRY IS NOT MADE IN THE 1 TABLE, THEN YOU CAN NOT MAKE AN ENTRY INTO THE MANY TABLE AND HAVE THEN RELATED.

Dale

 

[Marcellllo]

Thanks for respond rzw0wr

Actually one user can have more than one locations, and also can have different years of experience in different departments ( areas ) of company - I had to make some changes into model after this information ( ).

So if I want to enter data in database should I make one big table for everything or how should I add data into database ?

I have never worked with database with so many tables so I have no idea how to set up form to add data into db. Can u help me ?

Thanks for Your time and advices