Optional link between Invoice-Quotes or Invoice-Proposal

[ElGato]

Hello!

I need link Invoices with Quotes or with Proposal.
I mean Invoice must be linked with Quote or with Proposal. (not both, but one of these links must present )


What is the best/correct way to make that optional link?

I have 2 suggestions:
1. I can add 2 non-required fields to Invoice: quote and proposal. And add JavaScript code for testing these fields before submit. The test is: we should have only 1 filled field (not 1 and not 2).

How can I add that JavaScript code?

2. I can add 'link' and 'link_type' fields to Invoice. 'link_type' contain Quote/Proposal flag and 'link' contain correspond object id (QuoteID or ProposalID)

Thanks for any help.

[mvngti]

Create a flex relate field, and then put some customCode on the parent_type field so it has only the two modules as options instead of all modules.

M

[ElGato]

Thanks! That is exactly what I need!

I case someone have same problem, here is details about module restriction
http://apps.sugarcrm.com/forums/showthread.php?t=33719