Design help for a newbie - how to decide on tables and layout etc
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.