Novice to Access - autofill/lookup question

[Sarahgreenwich]

Hi



Folks - I'd really appreciate some help here if you can spare me a few minutes of your time (and possibly a few drops of your sanity). I work for a charity, which can't afford access training or my time to learn it properly! I don't know anything much about Access - so please understand when I don't use jargon - I'd also appreciate in your answer if you can tell me what things mean - I have no clue. Apologies I tried to upload a picture - but apparently don't know how to zip a file either.

I have 3 tables in my database:

Contact: which is for recording individual calls to an information service. This has a column 'Full name'. Full name brings up a value list box (which also allows new entires) of names which are recorded on the 'Client' table. It also has a personal details section for new users.

Client: personal details of all users to the service - including the columns address 1, address 2, full name, special needs etc - 'Full name' is linked to 'contact' and users of 'contact' table can select from a list of clients named in the full name column.

Organisation: a table of services users can be referred to. In 'contact' there is a list of organisations users can select they have referred to pulled from the column 'organisation name' in this table.

here is my wishlist... if you know how - please do share

1) When people use my form to fill out a contact made to the information service, I would like that if they select a known name from 'Full Name' (pulled from 'client' table) that it auto populates the other columns in both the form and 'contact' table with their address and any special needs etc from the 'client' table.

2) When people use my form to fill out a new contact made to the information service, I would like the information inputted into the form/'contact' table to appear in the 'client' table.

3) A way to tally how many times an organisation has been referred to - ie how many times has x been selected from the list of drop down options in the 'referred to' box.


I hope this makes sense. Thanks for reading!

Sarah

[orange]

A suggestion:
Why not name your tables more specifically to their use?

Organisation: a table of services users can be referred to.

Why not Services? and ServiceCalls?

Here is a tutorial that may help put many concepts into context for you. Good luck.
http://www.rogersaccesslibrary.com/T...lationship.zip

It has a business overview and follows a process to design tables and relationships. It also has answers..

Here is a link to youtube video for zip/unzip (there are many others).
https://www.youtube.com/watch?v=xBvZWyCf3xY