Help with database

[Teebird]

I need some help with my database and combo boxes please.

My cutdown version of my database is attached.

On the Members form - I have a combo box to lookup the City name and then add the corresponding values for State and Postcode. The problem I have is that I can lookup the City but it is not saving any values to my Members table. As soon as I close the form or move onto the next record, the City values are gone.

I also have a problem with the "Residential Address is Postal Address" checkbox. This was working before I started adding this combo box stuff. What I want it to do is when I tick the checkbox, the Residential fields will fill the Postal Address fields.

Yes I have had help from a few people but I still can not get it to work. Access Gurus, please answer my desperate cry for help...
Many thanks Tee.

 

[Ron_dK]

It looks to me that you have not defined any relationship between your tables. Start making the appropriate relationships between the Bike, City and members tables. After that you can create comboboxes on your form to enter relevant data on your members form.

Hth

 

[Teebird]

Thanks for your reply - but adding the relationships hasn't made any difference. My complete database has the relationships in place.

 

[Oldsoftboss]

Added relationships (Will help with queries).
Deleted State, Post Code, Country from the members table.
Changed the city field to number, and edited the query running the form to include the fields deleted above from the citylookup table.
Added the country to the city lookup table.
The members table now only saves the citylookupID. The rest is obtained through the query.

Dave

 

[Teebird]

Hi Dave Many thanks for your response and fixing my database. I have done everything you did and I now have all sorts of problems. I think I will give this City lookup the flick. It is now taking too much of my time to get it right.

Again many thanks.
Tee