simple address db - how would you do this?

[deb]

i need to create a simple phone/address db and i'm having a bit of trouble
making it simple, and i need to because the people who will be using it have
no access knowledge

i have a lot of companies and those companies have several contacts each
with different departments (one to many - no prob), however its all different
kinds of departments depending on the company. also, some smaller companies
have no contact person its just the company phone number so no contact name
(i hate dealing with null fields)

i have run this all into a really simple user form for lookup but what i
need to add is something again really simple to allow for multiple contacts
within each company (or not, in some instances)

i know an address db is probably the most basic db you could create but i
just cant wrap my head around this

 

[deb]

i'm overthinking this - its just a small subform huh?

 

[KARL DEWEY]

however its all different kinds of departments depending on the company.
also, some smaller companies have no contact person its just the company
phone number so no contact name (i hate dealing with null fields)

Company - main form
Department Contact Phone etc - subform
- if no department or contact name
default to a dash.

 

[deb]

thanks
--
deb

also, some smaller companies have no contact person its just the company
phone number so no contact name (i hate dealing with null fields)

Company - main form
Department Contact Phone etc - subform
- if no department or contact name
default to a dash.