Forum Discussion
Seeing information on both lists?
Hi All! I'm a freelance writer organizing my life on Sharepoint. I have a list called "Stories," where I keep all my ideas for articles. Once I pitch them to magazines, I have a separate list called...
Assuming the possibility exists that you send articles to multiple magazines, you have a many-to-one scenario that makes tying back submission information to your Stories list very difficult--you'd have to add fields like "magazine 1, magazine 2, ..." to account for articles getting sent to multiple places.
I think you might be better off using your Submission Tracker list to see where you've sent submissions. With that model, you're treating every submission as its own item, and in doing so, you can use filters or grouped views to discover where your articles were submitted.
Thank you! Will do
