Groups keyboard shortcuts have been updated
Dismiss
See shortcuts

Relationship inquiry: zero or many to zero or many

100 views
Skip to first unread message

blake...@gmail.com

unread,
Oct 6, 2019, 2:44:36 AM10/6/19
to Quick Database Diagrams
Is there a reason that "zero or many to zero or many" isn't an allowed relationship type? Relatively new to this, but I believe in general this is possible. Guessing the symbol would be: >0-0<

blake...@gmail.com

unread,
Oct 6, 2019, 2:29:52 PM10/6/19
to Quick Database Diagrams
Ah, I think I found my own answer. Realized I needed another table in this context.

Trevor Jobling (QuickDBD)

unread,
Oct 7, 2019, 4:28:32 AM10/7/19
to Quick Database Diagrams
Lol I'm glad you worked it out. This forum just worked as a rubber duck :)

Manuel Meireles

unread,
Jun 9, 2021, 7:09:24 AM6/9/21
to Quick Database Diagrams
Hi guys quick question

Its not possible with same column in a table define more than 1 join ? 

like this

Customer
-
CustomerID PK int FK >- Order.CustomerID 
 CustomerID FK>-OrderStatus.CustomerID 
Address1 string
Address2 NULL string
Address3 NULL string

Reply all
Reply to author
Forward
0 new messages