File Attachment field as Lookup Field
Does anyone have any suggestions for simple ways to either display or link to a File Attachment on a parent record within the child record? We have a parent table of procedures, which has a file att...
Forum Discussion
Can two separate child records (Issues) be pointing to the same parent record (Procedures)? Or in other words - can Procedure A be the resolution for both Issue B and Issue C? (EDIT: a 1-to-many relationship should be sufficient here: One Procedure has many Issues).
If one Issue can have multiple Procedures, you'll need a many-to-many relationship - between Procedures and Issues. (EDIT: to clarify when you'd need a many-to-many relationship).
There may well be some tricky and clever ways to set this up - but I think you'd be going to a bunch of effort to avoid the most straightforward way - which is a many-to-many relationship.
If one Issue can have multiple Procedures, you'll need a many-to-many relationship - between Procedures and Issues. (EDIT: to clarify when you'd need a many-to-many relationship).
There may well be some tricky and clever ways to set this up - but I think you'd be going to a bunch of effort to avoid the most straightforward way - which is a many-to-many relationship.