Recent content by edo17

Thanks so much for your help!

Great, thanks to you and everyone that helped me I'm realizing that there are a ton of problems with this database!

To do this I should need to create new fields, cleaning the data etc. right? Let's suppose that I can't do that, do you think it's still possible to establish relationships between tables ? If yes, what type of relationships?

Thank you!

Thanks @MajP! Yes when I started looking at the tables I thought that they were messy but I didn't receive any instructions on how to clean them. In that situation, without cleaning the tables do you think you can establish relationships between these? If you have to choose, what relationships...

Awesome, you're so clear and helpful with your explanations! What a great place I found!!!!! Thanks again

Clear and thanks for the advice. This forum is really helpful! Glad that I found it now that I'm starting so hopefully I'll be able to avoid many mistakes

Great so basically the relationship is independent from the subsequent data entry?

Thank you George now it's more clear!

Yes, here you go and here some doubts that I have. 1)Is it correct to use as PK EmployeeID in tblPayroll and in tblEmployeeNames and use AgencyID as PK in tbl AgencyNames? 2) What's the relationship between tblPayroll and tblEmployeeNames and between tblPayroll and tblAgencyNames? IMO between...

Can I ask you some general questions? (Btw it's a non graded practice assignment that's the reason why I'm asking here and from the teaching materials I still can't understand). He explained to us that in a one-to-many relationship, assuming a simple case with 2 tables: 1) Each record in the...

I still cannot figure out what relationship exists between these two tables since if it were a one-to-many / many-to-one I would expect duplicates in the EmployeeID field in the first or second table. (For example, that a given Employee from the Employee Names Table holds two jobs and that this...

Hi everyone, I have a question about relationships in Access. I'm new here and I just started using the program and I'm working on a small database with three tables. Table 1 and Table 2 have a field in common (suppose ID) and I want to understand the relationship between these two tables. Table...