Updating multiple tables in a ms access database
Afternoon all, Ive just switched from 97 to 2003 and while trying to get IT to fix the bugs (no wizards etc) in the installation i have come across an issue that i cant seem to get round.I provide a staffing database to the company that my team uses for the production of MI to the business.Don’t load more data than you need to I’ve bounded forms to tables with several million records with no problem, how? Here’s how: Say you have a table of customers called tbl Customers and that the primary key is Customer ID, to load just one customer in your frm Customers form you would use the following syntax: Where lng Customer ID is a variable holding the Customer ID you wish to see.Do design your SQL Server tables for optimum performance with Access Make sure you follow my guidelines for designing SQL Server tables with Access: If you store your password with your linked tables you’re just asking for it if it falls into the wrong hands.Instead use Ben Clothier’s method when linking tables, or recreate and delete them when your app starts and quits.We recommend using Active Directory and trusted links as your best scenario.This is basically a staff table with various fields and a couple of input forms for changes to be made.The changes are made by directly editing a copy of the master staff table from the form (i use a select query to filter the records, then amend directly by overtyping as necessary which is great for single records). I have a form which shows an entire team of people based again on a select query (the user selects the manager name and the form shows all the staff).
If there is a way that i can have say 10 rows of text boxes in my form and have a way to populate all of these with the results of a standard select query then i could add a tickbox as the criteria for updating which would help a lot, but i dont know how to bring all the records back into the form other than the way i do it now. With regards to your original question that completely forgot to answer.The usefulness of this kind of join may not be obvious given this particular example.For a better example, imagine a table of products that includes each product's retail price and a table of states and their sales taxes.Thanks Eddies Voicebox Please be aware the following: You select the new manager (A) of the current team ...Why can't you select the new manager for the old team that belonged to (A)???