I’m not sure how to explain this easily to be able to search it properly. I apologize if it’s been answered, but I couldn’t find anything in the good bit of searching I’ve done, probably because I’m not searching correct terminology or explanation.
I’m working (trying to in my spare time) on a fairly in depth field service app and I want to be able to add multiple notes to different tables. Example: I’ll have tables for Customers, Vendors, Employees, Machines, Service Cases, Work Orders and probably more. For each of these I want to be able to add multiple separate notes, that can be viewed in relation to the specific related tab le data. I could add multiple notes for each employee, for each Work Order, for each customer, etc. Essentially I need a many to many relationship for the Notes.
My question is, what is the best way to do this? Would I need a sperate column in the Notes table for each related table I want a reference to? Or is there a better/cleaner/more efficient way to do this?
LinkedIn
Twitter
