Relationship Error

[jay055]

Hello, I'm trying to link two tables together in a relationship so it's easier to find data and provide data redundancy.



I already managed to create a relationship with the Employee ID fields in the Users table and the Hardware Asset table.


Of course now when I try to link the software table to either the hardware table or the user table I run into that annoying "No unique index found..." error and now I'm stuck. Can someone give me a hand?

Thanks

[jzwp11]

Based on what you show of your structure, you would make the join between the user table and the software table not between the hardware table and the software table.

Now if the software is tied to the hardware, then your structure is wrong. The software in that case would be related to the hardware and not the user (at least not directly).

[jay055]

Thanks jzwp11,
Do you have a suggestion on how I could link them all together? I.E. Find either software or hardware (or both) that is assigned to a user? If that is possible.

Thanks

[boblarson]

Thanks jzwp11,
Do you have a suggestion on how I could link them all together? I.E. Find either software or hardware (or both) that is assigned to a user? If that is possible.

Thanks

As mentioned, the way you have it now, it should be a link between tblUsers and tblSoftware (EmployeeID to EmployeeID just like between the users table and the hardware table)

[jay055]

Thanks, but now it comes comes up with an Insert Subdatasheet dialog box when I open the user table and forces me to choose only one link.. Am I only able to see one link off of the user table?

[jzwp11]

You should be doing it with forms. You would base the main form on the user table and have 2 subforms--one for hardware and the other for software.

You can put the subforms into a tab control for a nicer looking form/subform design.

[jay055]

I see,
Thank You. My plan was to eventually use forms after I made sure I had the right structure, etc.

Thanks for your help guys.

[jzwp11]

You're welcome