Need help asap

[ysfpsu]

Hey guys,
So my boss needs me to do something with the form. I'll give you an example: Say the form/table has two fields Computer Name and User. Now one computer name can have multiple users and it can be any number of users (no set amount) she wants to be able to add one user at a time and not in the same field. She also does not want to have two different records with the same computer name but different users. The way I thought of doing this was to make a button in the form so when she needs to add more users to the form she can just click the button and another field would appear saying "user 2", "user 3"..etc. Is that possible or does anyone have a better idea?
Thanks in advance for the help guys

Yusuf

 

[ejstefl]

Sounds like you have a many-to-many relationships. This will require three tables:

tblUsers - to store info about users
tblComputers - to store info about computer
tblUsersComputers - to store the relationship between users and computers.

Once you have the data normalized, you could set up a main form based on tblComputers and a subformbased on tblUsersComputers that would allow her to add one user at a time.

The way your boss wants to do it seems to be to add a new column for each new user... this is not good design, and would be difficult to implement.

 

[ysfpsu]

I made the three tables and put in dummy information in tbluser and tblcomputer. Which tables should I relate and what should be my next step from there? I have just started using access so please bear with me

 

[ejstefl]

Take a look at the attached database. Should give you a good start.