Jump to content

Scheme for an editorial flow - Recommendations


Recommended Posts

  • Newbies

A newbie here. I just wasted a couple of FM Starting Point files after days of work so I'm here. 

 

My scheme is simple: I'm creating a solution for a press house and I'm adapting the FM Starting Point to a degree for job tracking and inventory. 

My basic entities are the following: 

Authors for each book or books. (I created a new table for Authors duplicating the Contacts one)

Books in editorial process assigned to one or several authors, to editorial staff (editors, designers) and to external suppliers.  

I'm using Projects for these books in progress. 

But then I have the already completed and printed book with the same title and I use Products for this one but I don't manage to create a logical flow from book in progrees to book completed and already in inventory. 

I know is easy but I don't fully understand relations and dont want to mess, again, the nice relationship graphics of the Starting Point solution. 

 

Link to post
Share on other sites

I would suggest you use a single table for all books and a field in that table to indicate the stage of progress - including completed. Unless you have some additional requirement that you did not mention.

 

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Who Viewed the Topic

    1 member has viewed this topic:
    wendykdt 

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.