Auto fill

[Cherie]

Hi, I hope someone can help me with a few problems I am having.

I will post them seperately.

I have setup a table of the following items: Zip Code, State, County/Borough, and Diocese. There are no duplicate Zip Codes.
I would like tp imput the Zip Code and have the other fields auto populate. The Zip Code can be accessed through a drop down.

Thanks for your time and attention.

Cherie

 

[AncientOne]

When do you want this "Autopopulate" to happen? On what, a form or a report? And what sort of control are you wanting to populate?

 

[Cherie]

I have made a database to log our incoming calls. I have a table set up to record all the basic information. I then have tables set up with relationships for the following Zip Code, City, State, County, and the Diocese of the caller. We type in name, address, DOB, date/time of call, why they were calling and how we resolved the call with another date/time of the resolution. I would like the city, state, county, and Dio to fill in the approprate fields when the CSR types in the ZC. I am self taught on Access so talk to me like a 3rd grader(HA,HA). I have come a long way in a year, but still am lost when it comes to the bells and whisltes of Access.

Thanks for your help!

 

[Fizzio]

Cherie, this is very relevant to your subform question and I would fight the urge to store duplicate data - if you store the ID only, you can 'lookup' the relevant data from the student table and display it anywhere you want (Sorry to butt in AO)

 

[Cherie]

Thanks to both of you! I have attached a copy of the db on my other posting if AO wants to look at it too.

I have been pulling my hair out looking through help and the books I have. I am glad I found this group! Thanks a million.

 

[Fizzio]

No Attachment there Cherie

 

[Cherie]

The zip file is 257KB. Could that be the problem??

 

[AncientOne]

Remove any reports, forms, etc. that aren't relevant and then try compacting the database before zipping it.

 

[Cherie]

here we go again. try this. Thanks!

It was still 223kb

I can't really delete much more. I broke the db down by problem and have 2 seperate dbs for your review. I hope it will this will work.

 

[AncientOne]

I've made some changes to your db, and created a query which brings all the rows together for you to use in your call form.

A lot of work still needs to be done to the structure of your database to avoid repetition, such as occurs in your Call table.

 

[Cherie]

AO - Is there something else I need to do to get the fields to auto populate? It does not seem to be working.

Thanks again for all your help!

 

[AncientOne]

Cherie

All I did was to rearrange your tables to allow you to run a query to produce rows containing all the information you need for any given zip code.

I'll look at the db again to see the optimum method to display this info and post again later.

 

[Fizzio]

I've posted a restructured version in your other post.

 

[Cherie]

Yes, thank you. I am looking at it now. I will have some questions but I will ask tomorrow. Thanks sooo much. Have a great evening!

 

[Fizzio]

Evening is nearly over - time for bed (Unlike Rich who never seems to sleep )

 

[Cherie]

AO - Have you had a chance to look at the Autofill problem? Someone mentioned that I may have to write some kind of code. Is this correct?
I have never written code before. So I was no sure. I thought the auto fill would be a simple thing to do.

 

[Fizzio]

Cherie, did the Db I posted back not give you an easier and more robust way of structuring your data?

You are looking at all sorts of problems if you persist with the structure you currently have.

 

[Cherie]

Fizzo - It is ok. However while I was testing it there are a few things that didn't work for us. I was trying to work on both to see if I could swing my managers vision that she has set in her mind.

First problem if entering a new student it works fine exept for the auto population of the dio and state. I think I can fix it later, as I am focussing on the bigger areas.
However when entering a new call for a student that is already in the db it treats it as a brand new student. It does not pull the calls previous to this call. How can I fix that?

 

[AncientOne]

Cherie

the way I restructured your tables and created the relationships did enable all the address data to be gathered into one row. I agree with Fizzio that the table structure for the other elements needs to be revised - however, I don't want to feed in a different schema to you that might confuse. However, if you have questions which I might be able to answer, send me a pm and I'll give you the email address you can use to send me your complete db.