ER-D Really Confusing! Please Help!

[sirantonycartwr]

Hello, Im creating a database for a charity just to get some experience and im stuck on something - my table structure.

I know you might find it a bit difficult because you dont know the background info but i need the database to be able to let customers and members make bookings. Ive thought of putting both customers and members in one table but i dont want it to get complicated and messy, although i will do that if there is no other way.

The ER-D is attached.


Is there a solution to my dilemma?
Ant...

 

[neileg]

You should include both in one table if for no other reason than cutomers could become members or vice versa. Use a field to indicate their status and anytimne you just one one category, use a query to filter out the ones you don't want.

 

[sirantonycartwr]

Thanks, Thats my solution too!
Thank-you, Ant...