one field with multiple values

[grumbachr]

many to many to many... (argh!) ? in my database i need to be able to assign multiple values to one field.

its a situation where one person can be assigned multiple devices.

and one device can be assigned to multiple people. i currently have a users database with a device id and a user database with a user id and both have proper relationships to link old records together.

the trouble comes in when i am creating new device records and assigning them to a user. i guess i could make multiple device id fields for each user but the number varies from user to user. some might need 1 some might need 5. and having a bunch of extra fields makes things messy.

i hope I've explained that well enough if not I'll try to answer any questions to have you understand it better.

[-Queue-]

Do a search for +join +table +relationship on this site. There are many previous threads on the subject of many-to-many dbs.