I’m having this many to many relation error <https...
# orm-help
c
I’m having this many to many relation error https://github.com/prisma/prisma/issues/4418 has anyone run into something similar?
c
@captDaylight I could be wrong about this.. but why are you manually creating the relationship table? Why don’t you let Prisma do it automatically for you? Or you may need to switch the order around. For example: instead of
Copy code
type ShortCodeTx {
  id: ID! @id
  jars: [Jar!]! @relation(link: TABLE, name: "ShortCodeTxJars")
}

type ShortCodeTxJars @relationTable {
  jar: Jar!
  shortCodeTx: ShortCodeTx!
}

type Jar {
  id: ID! @id
  transactions: [ShortCodeTx!]!
}
try
Copy code
type ShortCodeTx {
  id: ID! @id
  jars: [Jar!]! @relation(link: TABLE, name: "ShortCodeTxJars")
}

type Jar {
  id: ID! @id
  transactions: [ShortCodeTx!]!
}

type ShortCodeTxJars @relationTable {
  jar: Jar!
  shortCodeTx: ShortCodeTx!
}
I’ve noticed that order matters for Prisma
c
Prisma’s change on April 17th https://prisma.slack.com/archives/C0MQJ62NL/p1555515957024200 changed the datamodel syntax and its now required to manually call out your relations