Consider the following:
Clienti_Ricette (Customer_Prescriptions) holds the information for the vouchers of different worths that customers may or may not have/use.
Therefore I'd like to do so that Ordini (orders) be related with Pagamenti_Ricette (Payments_Prescriptions) only when a given order gets paid with the prescription.
How to create such a "conditional relationship"?
Will a Yes/No "Pays_With_Prescription" field linked to IDPagamento (PaymentID) work?
Clienti_Ricette (Customer_Prescriptions) holds the information for the vouchers of different worths that customers may or may not have/use.
Therefore I'd like to do so that Ordini (orders) be related with Pagamenti_Ricette (Payments_Prescriptions) only when a given order gets paid with the prescription.
How to create such a "conditional relationship"?
Will a Yes/No "Pays_With_Prescription" field linked to IDPagamento (PaymentID) work?
