Is it possible to have a lookup field on a custom object in a way that the user could enter a new value?
For example, let's say I've got object A__c and I have a field on that object called Description__c which is a lookup field on Products.
With the standard lookup field if I enter a value that doesn't exist in the lookup it throws an error.
Is this possible? Is it possible to enter a value that doesn't exist without getting an error?
Or do I need two fields?