Linking tables and using forms

[natcas]

hi, im new to access, but have a basic understanding of db's (sort of), so any help would be appreciated...




ive made a db to keep a record of my employees and then keep a record of the addresses they attend.


each employee will tend to visit numerous addresses in any given day so ive made a table for employees and a separate table for the addresses they visit...


i then made an 'employee form' that is generated from my 'employee table' (standard stuff like name, address etc, nothing fancy here) so it is more user friendly...


what i want to be able to do is push a button on the 'employee form' which will then prompt me to add an address that will only be linked to that specific employee.


i guess in esssence im looking for a way to link a specific employee to a bunch of addresses, and be able to data entry it on a form....

thanks...


hope ive explained this enough...

[orange]

ive made a db to keep a record of my employees and then keep a record of the addresses they attend.

What tables do you have in your database?
Why do your Employees attend addresses? (I think there is a hidden entity here -- Customer/ServiceCall/PatientVist???)

No you have not explained/described it enough.

For the readers to help you in a meaningful way, they have to know WHAT you are trying to do. WHAT are the things involved? How do the things relate to each other? What information do you wish to record/keep/know about the things?

see http://forums.aspfree.com/attachment...2&d=1201055452
and http://www.rogersaccesslibrary.com/T...lationship.zip

[natcas]

hey mate, thanks for the reply.

basically the company has about 50-80 employees currently, its an alarm installation company so staff are constantly doing service calls, upgrades, installations etc at various addresses around the state....

so its pretty basic at the moment, i have an employee table (with basic personal particulars) and then also another table with customer addresses in it that the guys visit.

i would like to be able to bring up an employees details on the form ive made, hit a button to add an address that they go to, so that later on (if theres a problem or complaint) i can look up who went to the address...

i didnt want it to get too complicated but i will also add a vehicle table so that i can also link the same employee to the service van that they are using for the day (so if a speeding ticket comes in i can see who was meant to be driving that day)....

anyway, thanks for the advice.