Form pick-up foreign key value from grid: how to maintain referential integrity?

Applications Forms
#1

I have a proposal form. In the form I can select a customer (Id) by a pick-up link. This works fine. The user can also enter the customer id manually if he wishes. Problem is that the user can also enter a customer Id that doesn’t exist. In this case the proposal is saved with the non existing customer id!

Is there a standard SC way to prevent this? or do I have to program this myself?

thanks.

#2

Re: Form pick-up foreign key value from grid: how to maintain referential integrity?

I supose you can create a onChange Ajax event making a lookup of your customer’s id