Updating fields in access awesome dating games online
There is a wizard that will help you with an update query - if you will have to learn them why not now. HTH As you have discovered, a datasheet or table may *look* like an Excel worksheet, but it isn't even close to being the same thing.Here's the HTSUS table: When a person selects an item in the "Products" field, it shows the Product Name.
You cannot use an update query to add new records to a database, or to delete records from a database.
To add new records to a database you use an append query, and to delete whole records from a database you use a delete query.
I don't have a lot of experience with Access, and I'm not sure how to accomplish this task.
I've built an entry form, and have a field called "Product" which is a drop down that pulls the information from the Product table.
You can select multiple tables by holding down the Update Query from the popup menu.