473,382 Members | 1,635 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

How to update multiple records with generic information

Hi,

I have an existing database that I would like to edit.

At the moment our system only allows me to update one record at a time, but I have jobs that could have up to 200 records per job that has some generic information that needs to be updated on each record.

Is it possible to have a form with all the generic information and then a way to select the pre-loaded records that is relevant to the specific job? I would like to try and shorten the loading process by filing in the generic info first and then updating all the relevant records all at once.

Please help...
Sep 23 '15 #1
2 1378
Seth Schrock
2,965 Expert 2GB
Generally this would be done via an UPDATE query, however I'm not sure what mechanism you might have in place that would be limiting you to only update one record at a time, unless you are just referring to the fact that manually changing a record only lets you do so one at a time. You would just have to provide some sort of criteria to tell the UPDATE query which records you want changed and then provide the values that you want those records to have.
Sep 28 '15 #2
NeoPa
32,556 Expert Mod 16PB
It sounds very much like your database design is the problem here. If you have data repeated across multiple tables then your design is not normalised and this is a big problem, that will only get bigger the longer you continue with it.

You'll find some help understanding the problems in Database Normalisation and Table Structures.
Sep 30 '15 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Olivia Towery | last post by:
SQL 6.5 Database I have a list of registrants and I want to use a check box after each record to show those who attend and then post all with one submit button. Any help is appreciated. --...
4
by: Mark S. | last post by:
Hi, I have a weird UPDATE sequence I want to perform. The customer does not want to use INSERT and DELETE. My issue is that there are multiple Mat_Class, but I do not wish to hard code each one...
1
by: A P | last post by:
How can I go about updating multiple records or deleting multiple records from a DB at a time?
1
by: Kenneth | last post by:
Dear all, How can I update multiple records in using ASP.NET? Currently I have a table which require to update frequently but I can update records one by one using DataGrid. Kenneth
1
by: jayz24 | last post by:
Hi everyone! I'm new in this forums and new in the line of programming..A Beginner.. I have a problem, I don't know how to populate a multiple updates. Anyone who have codes for this? Here's...
1
by: jllopez | last post by:
I need update multiple records in the datagrid but this is using ASP.net and VB, somebody that I can help?
1
Fary4u
by: Fary4u | last post by:
how can i update multiple records corresponding to perticular ID & update values in one go ? mode_a contains ID No. Dim mode,mode_a,i mode=Request("t1") mode_a=split(mode,",")
1
by: saifulhaque | last post by:
Hi Dear How can insert, Display ,update multiple records simultaneously through GridView in Asp.net. I have Button for insert, update . I want insert, update multiple records through a GridView...
14
by: Diana Miller | last post by:
Hi All, I have an Access 2007 report where the user selects a date from a combo box. After selecting the date, I need the AfterUpdate() event of the combo box to fill in text fields with a...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.