Creating Contacts table for database.

[Mary Wildavsky]

I need to create a table of contacts which covers

a) Title=Mr. or Ms., first name, last name =A, ;

: Mr & Mrs., first name, last name=A (include spouses name somewhere for reference);

c) Title=Mr. first name, last name=A & Mr. first name, last name=B;

d)Title=Ms. first name,last name=A & Ms. first name last name=B, e) Title = Mr. first name, last name=A and Ms. first name, last name=B.

Then I must be able to produce mailing labels appropriately i.e. Mr & Mrs... or Mr. A & Mr. B...Mr. A & Ms. B....at (address).

I am confused. Do I have to make multiple records or can there be one record per family.

Appreciate any suggestions. I am a beginner.

Thank you.

[mr_vodka]

See this thread.

Household letters

[Mary Wildavsky]

Thank you so much. I will follow up your suggestions.

(have you tried Hangar Onehttp://fmforums.com/forum/skins/Crisp/icons/tongue.gif)? locally produced in Alameda - Bay Area, CA)

Mary