Can I update multiple fields in a record

Hello! Help please! I am trying to create a user friendly database for use with our construction company. I am trying to create a form (which seems to be the most user friendly) that pulls existing records and updates fields on the table based on the record found. See below...

ID - (Auto numbered - identifies the existing record)
Field 1 - Step 1 - Search existing records using this field.
Field 2 - Step 2 - Auto populates based on the existing record. If duplicate Field 1's are found, there will be a drop down to select the correct record by the text in Field 2.
Field 3 to Field 8 - Step 3 - All these fields auto populate based on selected record from Steps 1 & 2 in order to update the record. If no data exists, use the form to add data and update existing record.

Jan 11 '20 #1

Subscribe Post Reply

4920

SioSio

272

256MB

What is the reason for performing this processing using the API?
And
What language do you want to write your program in?

Jan 14 '20 #2

Rabbit

12,516

Expert Mod 8TB

I suspect they posted this in the wrong place and meant to put it in the Access forum.

Jan 14 '20 #3

ogn993160g

Thanks you guys problem solved..

Aug 15 '20 #4

Similar topics

Update Multiple Rows In A Form

by: Colin Steadman | last post by:

Part No Description Quantity 45643 Random part 10 45678 Another Random part 7 98944 And another 1 <submit button> ...

ASP / Active Server Pages

Update multiple fields Accross a Join

by: Duane Phillips | last post by:

"David Portas" <snipped for brevity> wrote: Example 1: > > UPDATE table_a > SET col = ? /* Unspecified */ > WHERE EXISTS > (SELECT * > FROM table_b > WHERE table_b.key_col =...

Microsoft SQL Server

Set multiple fields equal to one value

by: Mangler | last post by:

I need to set up my front end app to update multiple fields with the same entry. See below. Database: Testing Columns: Recdte Invdte

ASP / Active Server Pages

How to Update multiple fields in a table

by: tara99 | last post by:

Can some one tell me the correct syntax of Update statment for updating multiple fields. I want to update few item in record (few fields i a table). Thanks

Microsoft Access / VBA

How to Update Multiple MySQL Database Records

by: aris1234 | last post by:

Hi.. How to Update multiple record ?? I have 3 file : (my code no have error) "tesupd.php" process to > "codetesupd.php" process to "update.php" in page "tesupd.php" have a checkbox for...

PHP

Using the Combo Box's Not In List event with multiple fields

by: Jason Northampton | last post by:

Hello This is the first time I've used a discusion forum and up until now I have managed to use and or modify VB code from the various sites on the web, until now! This is a simple problem and I...

Microsoft Access / VBA

Checking for Duplicates in Multiple Fields beforeupdate

by: john.cole | last post by:

I have searched all the groups I can, and I still haven't been able to come up the solution I need. I have the following problem. In my form named sbfrmSpoolList, I am entering a job, spool and...

Microsoft Access / VBA

template for an UPDATE query that shows how to UPDATE multiple fields

by: Carl23 | last post by:

Your template code works great for INSERT. Is there a template for an UPDATE query that shows how to UPDATE multiple fields INTO a table called TEMP from 2 other tables with a common field report_num...

Visual Basic 4 / 5 / 6

Can I update multiple fields in a record on a table using a form?

by: ConstructnGirl | last post by:

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

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$) { } ...

Javascript

Batch import of multiple excel files into the database

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...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

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...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

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...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++