Hey theory, not sure what package this is but i am quite familar with ms access as i did a course on it.

From what i can see you don't have any relationship in your tables (anything linking projects and clients) You are currently using client name, which isn't a unique identifer...what if several clients share the same name?

The solution is to create a unique key for both tables and this will be the primary key and thus create the relationship, something like "Client ID".

Hope that works