Help with Access

[Guest]

Okay some people say they're new to access but I'm fresh out of the box baby!
So I'm trying to create a contact database which will incorporate several
contact types - I'd like to have as a combo drop down box for the contact
type on a single form for all but also including different fields relating to
a specific type. Is it possible?
For eg. if you select a person as a friend then there would be different
fields on the form to say if they were a corporate person?

Can you advise me please.....

 

[Guest]

If you are THAT fresh out of the box then you should crawl before you can
walk ;-)

Learn about normalisation and proper database design before you even think
about forms.

 

[John W. Vinson]

Okay some people say they're new to access but I'm fresh out of the box baby!
So I'm trying to create a contact database which will incorporate several
contact types - I'd like to have as a combo drop down box for the contact
type on a single form for all but also including different fields relating to
a specific type. Is it possible?
For eg. if you select a person as a friend then there would be different
fields on the form to say if they were a corporate person?

Can you advise me please.....

You may want to read up on some of the basic principles:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

What you're describing is a "many to many" relationship. Each person may have
zero, one, or more contact types; each contact type will apply to zero, one,
or more people. The way you build this in a relational database is to add a
new Table with fields for the personID and the contacttype fields; you would
add one record for each type for each person (using a subform, typically).

John W. Vinson [MVP]