Access Newbie database design question

[sunrise06]

I am trying to learn Access by creating a database from scratch. This database will contain contacts that are members of different groups. There are also spouses that belong to their own set of groups but I want to be able to associate the relationship. Do I need two separate tables, one that will contain the spouses names and contact information or should I put all contacts into one table and add a field for the spouses name?

Any advice will be greatly appreciated.

Thanks

 

[xenou]

Not sure how it matters. Spouse that is married. So let's simplify it by saying all the males can be in group A, B, or C and all females spouses can be in group X, Y, or Z.

Okay. Well that was a joke. Now, we only need to know if the person is male or female and the rest is easy (another joke - unless this is an actual rule that all males are not spouses and all females are spouses).

 

[xenou]

Have you come up with anything yet? Post your table design for review. Do you also have a table for your groups?

 

[bobsan42]

I believe what xenou is trying to say between the jokes is that it is much more important to sit and give some thinking about what exactly you need to achieve. Remove all unnecessary details etc.

Without us knowing you goa; - it is hard to give the right ideas and clues.