If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
simple address db - how would you do this?
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 |
#2
|
|||
|
|||
simple address db - how would you do this?
i'm overthinking this - its just a small subform huh?
-- deb "deb" wrote: 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 |
#3
|
|||
|
|||
simple address db - how would you do this?
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. -- Build a little, test a little. "deb" wrote: 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 |
#4
|
|||
|
|||
simple address db - how would you do this?
thanks
-- deb "KARL DEWEY" wrote: 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. -- Build a little, test a little. "deb" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|