Need Assistance w/ Look up Field (3rd Request)
Hi Guys:
I'm sure you're really swamped, but for the past week I've been trying to contact someone that might be able to give me the answer to the following question:
I have two views (Brokerage and Agent) and the relationship between them is that "an Agent belongs to a Brokerage." In setting up the Agent view I have added a "Lookup" field to pull up the "Brokerage name." So when I save an Agent I assume it saves the name, not the ID, of the brokerage in the Agent view. In a traditional database system, you would save the "Brokerage ID" in the Agent table, not the Name. In Zoho, is there a way to provide a lookup field where the a "value" of Select box is the ID while the displayed text is the Name? Should I just save the name in the Agent table rather than the ID?
Is there someone that might be able to follow up with me about this question so we can get past this road block?
Thank you!
Chris