How can I insert two records with the second using the result of the first. Like adding an invoice with line items. Need to have the invoice number before inserting the line items. I tried the below, but it’s a hot mess I know. EDIT: figured it out. Below works:

const addedDate = new Date().toISOString();
const noteAdded = prisma.note.create({
  data: {
    description: description,
    title: title,
    active: 1,
    createDate: addedDate,
    noteChangeLogs: {
      create: [
        {
          changeDate: addedDate,
          operation: 'Created',
          details: '',
        },
      ],
    },
  },
  include: {
    noteChangeLogs: true, // Include all posts in the returned object
  },
});

This was helpful: https://www.prisma.io/docs/concepts/components/prisma-client/relation-queries

@Peter Kellner 👋 You can also do that with long running transactions that we have recently introduced 🙂 https://github.com/prisma/prisma/releases/tag/2.29.0