Hi all,
I have an app and I want to add the ability to log mail that comes into the office where the app will be used. The primary focus of the app is file management. In the past, tables that have been similar in relative position to this one would just be one-to-many relationships with the main table. For example, I can add invoices to files in my app.
In this case, I'd like to be able to relate some mail to some files, but there are DEFINITELY going to be cases where some mail just doesn't go with any particular file yet it needs to be entered into the app and appear in reports with the other mail (at least any report not specifically listing mail associated with files).
I'm assumming I should not have the file table pk as a fk in the mail table and therefore shouldn't have the tables related in the relationships window. But how else do I associate some mail with some files?
Thanks for any guidance. I know this is pretty basic but it's just the first time I remember running into this type of situation.
T
I have an app and I want to add the ability to log mail that comes into the office where the app will be used. The primary focus of the app is file management. In the past, tables that have been similar in relative position to this one would just be one-to-many relationships with the main table. For example, I can add invoices to files in my app.
In this case, I'd like to be able to relate some mail to some files, but there are DEFINITELY going to be cases where some mail just doesn't go with any particular file yet it needs to be entered into the app and appear in reports with the other mail (at least any report not specifically listing mail associated with files).
I'm assumming I should not have the file table pk as a fk in the mail table and therefore shouldn't have the tables related in the relationships window. But how else do I associate some mail with some files?
Thanks for any guidance. I know this is pretty basic but it's just the first time I remember running into this type of situation.
T