Base: multiple RECORD "INSERT INTO"

[jw1]

I’m trying to update multiple records in a Libreoffice Base database I use to keep track of many electronic equipment items.
The database includes a “Devices” table as well as an “Incidents” table in which I can record historical events related to individual devices, (returned, repaired, discarded etc.)
I would like to insert records in the “Incidents” table on multiple, (but not all) records without individually entering info for each item in my form.
I have searched and found some ideas for how to accomplish the task and have come up with the following SQL statement to achieve the task:

INSERT INTO “Incidents”
(
“Device”,
“Incident Date”,
“Incident Description”
)
VALUES
(
SELECT
“Serial Number”
FROM
“Devices”
WHERE
“Devices”.“Location” = 5,
‘2024-02-21’,
‘(text describing an change of location incident for multiple devices)’
)

However, this returns an error: “1: Single value expected” when executed

The following does execute without error and adds a single record when tested:

INSERT INTO “Incidents”
(
“Device”,
“Incident Date”,
“Incident Description”
)
VALUES
(
‘012570’,
‘2024-02-21’,
‘(text describing an change of location incident for multiple devices)’
)

Do I have a syntax issue here, or am I going about the task incorrectly?
Any help would be greatly appreciated and thank-you in advance.

[sokol92]

In VALUES you specify three fields:

"Device",
"Incident Date",
"Incident Description"

but insert one:

"Serial Number"

[cpb]

@jw1,
.
you probably need something like this.
note the omission of the VALUES clause which limits inserts to 1 row at a time.

insert into "Incidents"
	("Device","Incident Date","Incident Description")
select
	"Serial Number",
	'2024-02-21',
	'(text describing an change of location incident for multiple devices)'
from
	"Devices"
where
	"Location" = 5
;

[RobertG]

@jw1 : You subselect shows many “Serial Number”, but the Insert should get a value for “Device”. “Incident Date” and “Incident Description”.

Please describe by an example what you want to insert.

or: Create a query for the subselect. Copy the query and paste it in table “Incidents”. Choose the one field, which should be inserted for “Serial Number”.

[jw1]

Yes. The select uses “Serial Number” because that is the name of the column in the Devices table
The Serial Number appears in the Incidents table as the “Device” column
There is a 1 to many relationship

[jw1]

Thank-you for the help cbp - that worked for me

[iplaw67]

Shouldn’t you be using the UPDATE command rather than INSERT ?

[jw1]

Sorry for the late reply iplaw67, Insert is the correct command, as I am adding info as new records. The response from “cpb” worked and I marked that response as “solution”