This may sound a bit strange as to why I would want to do this, but I need to be able to enter a name into a text field and have it update a look up reference field. I can do this with the id, but I need it to relate based on name. So if I am in a field editor using the model Patient and Patient has a lookup field to "Illness " object, I need to be able to have a text field from patient choose the Condition 1 record based on name, not id. The basic question is that I can update the field if I use the id of the illness record, but I can’t get it to work using the name of the illness record. Is this possible?
I don’t think I entirely followed you. Can you create your condition on Patient__r.Name rather than Patient__c (Or Illness__r.Name instead of Illness__c)?
Thanks for your reply. I got all twisted up in the logic of this. I was trying to take something that was already built and convert it into something it was not. What I wanted to do was impossible. I need a junction object and it is easier to accomplish with a table. Once again, thanks for you help.