Navigating Form (comprised from multiple tables) by Record
Posted on 2012-04-10
I am VERY new to Access (only 8 weeks using it now), so please excuse my ignorance!
I have created a database using Access 2010 to provide a solution to a long standing problem with difficulty accessing legal and formality information within my organisation. The database comprises 29 tables, each dealing with a different aspect of law and custom, plus 4 forms to access various aspects of the information. The information is for reference only (there is no requirement for the user to enter any fresh data). The forms each use information from between 8 - 17 of the tables (55-120 fields per form). On a simple level they work well. Each record is sorted by country alphabetically and, by using the arrow buttons automicatically created at the bottom of the form, I can navigate through the records for each country. I have input information for 10 test countries at present, however, there will be records for over 80 countries, so this way of moving between records will not suffice in the long run.
I would like to create a list box or combo box (or other method? navigation form maybe?) to show the countries alphabetically, so that when the relevant country is selected in the box, the form shows all the information for that country. It works for test forms that only have information from one table, but as soon as there are multiple tables involved, it only changes the record information for the one table. The rest of the form is unchanged and therefore shows information from the previous country record.
Any help would be greatly appreciated, but please be aware that I have no experience writing code so, if the solution includes code, a real idots guide is required! :^)