Recent content by Marcellllo

Thanks for perfect example way2bord ! Wow that is exactly the way I would like it to make it in. But there is only forms for location and user id ...and can I make one from for all data I would like to store in database or do I need to have separate form for each group ? 10x :)

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...

Thanx for respond way2bord To be honest, I dont quite understand Your advice. ( probably because I am rookie but just to be sure :D ) That 2 separate lists means 2 separate forms for each table ? And than one form ( list ) to put data in that 2 separate forms ? Is there a possibility...

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 ...

Thanx for explanation ;) Ok I va made it according to Your advices, but I am not sure how to insert data into new database ... because when I use form it put data in Contractor and in Location, but it do not make connection in User-Location table ... do You have some idea why ? Is there...

Thank You for quick respond ;) I had it in way that You suggest, but there is like 600 combinations of all posible skills and I found it too unpractical have them under 600 IDs in case of reporting and so on. Do you have some idea how can I do it ? Because some skills Has only one level for...

Thank ford Advices guys !! I created this ... what do You think about it ? Are there any mistakes, that You can see and I dont ? Thank You for Your help :)

way2bord thank you very much for your table design. May I ask what if one worker worked during his life in two different areas ? I believe it would cause duplicity in first table. PMID, SkillsID are automatic numbers or the same as eTime User ID which is combination of ID and eTime User ? Thank...

Hi Pat, Thank You very much for Your advice ;) That multiple issue stuff is probably because of bad organization of data before .... so I need to make each eTime User ID in Contractor table unique ? But how should I solve the problem with situation when one worker ( eTime User ID ) worked...

Hi Pat, thanks for you respond :)) Well eTime User ID is combination of User name with automatic number but it does not makes each record unique becase one person ( with one eTime User ID) might worked with different project managers ( PM Name ). The second issue is that that each person may...

Hi guys ! I am new in using Ms Access and I have to design a database about external empolyers. Right now, I have something like that but I am not sure if it is correct because it does not look like most databasesb I have seen on forums or on the internet In db i have 3 tbls tblContractors...