AnsweredAssumed Answered

Design help for a newbie - how to decide on tables and layout etc

Question asked by jasonkimmings on Aug 18, 2015
Latest reply on Aug 19, 2015 by jasonkimmings

Title

Design help for a newbie - how to decide on tables and layout etc

Post

Hi. I've just moved from Bento and this is a big leap. If someone could suggest the best way to set this out I'd be very grateful!

 

         
  • I have a number of clients which I need their name, company name, telephone etc
  •      
  • Each contact will have a project or more assigned to it
  •      
  • Projects can be of a different variety, each of which will need different fields associated with it (eg. wedding client will be completely different to web design client)

How many tables should I have and how can I only show the relevant data when I select a particular client? And each client may have one or more of each project type.

Thank you!

 

 

Outcomes