Search results

I've done some more research based on all of your suggestions, and I might have a solution that works for me (assuming it would actually work at all): A junction table with three columns: junction table PK, and two other columns: Asset1 and Asset2 (these just contain PKs from the AssetList...

I did see that during my research, but then I ran into the issue that assets aren't always owners or owned, just associated with one another. Would it be bad practice (or even possible) to use the junction table to search for associated items both ways i.e., listing items Owned by an asset, as...

Thank you for the welcome, and for the lightning fast responses! The MVF isn't set in stone (I had seen in my research that a lot of people don't like it, so I'm not surprised with this response!) but I'm not sure how best to structure a many to many relationship when linking together records on...

I'm building a database for tracking assets and wanted a way to associate assets with one another (like a sensor that is currently plugged into a detector would be associated with that detector). The way I'm currently doing this is by using a multi value field linking back to the same table...