title: Can Foreign Key on a table be three different tables as primary keys (each table primary key data is different)?
body: <p>I have a reminder table (ParentId) - Foreign key to ProductId from Product and also OrderId from Order table. Is it possible? When I try to insert the data for the Reminder table belongs to OrderId, I'm getting Foreign-Key constraint error.</p>
  
  <pre><code>Reminder
   - ReminderId
   - ParentId
  
  Product
   - ProductId
  
  Order
   - OrderId
  
  ALTER TABLE [dbo].[Reminder]  WITH NOCHECK ADD  CONSTRAINT [FK_Reminder_ProductId] FOREIGN KEY([ParentId])
  
  REFERENCES [dbo].[Product] ([ProductId])
  GO
  
  ALTER TABLE [dbo].[Reminder] NOCHECK CONSTRAINT [FK_Reminder_ProductId]
  GO
  
  ALTER TABLE [dbo].[Reminder]  WITH NOCHECK ADD  CONSTRAINT [FK_Reminder_OrderId] FOREIGN KEY([ParentId])
  REFERENCES [dbo].[Quote] ([QuoteId])
  GO
  
  ALTER TABLE [dbo].[Reminder] NOCHECK CONSTRAINT [FK_Reminder_OrderId]
  GO
  </code></pre>