mattpearcey
Technical User
OK - i am now, by user request, having to make additions to my database that i need some help with please?
I have my main database that contains information on banks. One fo the tabs contains location information. One field is Country.
The request is to add more contry information on the database. Now i want to make a new table, and new form that contains this information (spoken languages, currency, geographical background, etc)so that when the user clicks on a button next to this Country field, it wil open a new form that contains information on the counryt that is on view.
Now i have sort of got that working, in that i get the form to come up ok, with the country entered. It also shows the number of records on the bottom (so the amount of records i have inthe main table for that couuntry.
But here are my problems:-
a) all the other fields have name? in the boxes and cannot be populated! i have tried ways of getting over this, but cannot get it to work. Help?!
b) how do i get a field to show the banks for that country (so the records on view) in say a list box or combo box, and then get this to link back to the main form, so that i can hit another button once ive selected one of the banks in that country, and it will go to that record in the main form?
Sorry for the long 'essay type' question. Thank you for your help already.
Matt Pearcey
I have my main database that contains information on banks. One fo the tabs contains location information. One field is Country.
The request is to add more contry information on the database. Now i want to make a new table, and new form that contains this information (spoken languages, currency, geographical background, etc)so that when the user clicks on a button next to this Country field, it wil open a new form that contains information on the counryt that is on view.
Now i have sort of got that working, in that i get the form to come up ok, with the country entered. It also shows the number of records on the bottom (so the amount of records i have inthe main table for that couuntry.
But here are my problems:-
a) all the other fields have name? in the boxes and cannot be populated! i have tried ways of getting over this, but cannot get it to work. Help?!
b) how do i get a field to show the banks for that country (so the records on view) in say a list box or combo box, and then get this to link back to the main form, so that i can hit another button once ive selected one of the banks in that country, and it will go to that record in the main form?
Sorry for the long 'essay type' question. Thank you for your help already.
Matt Pearcey
