I need some help.  Zoho is great at editing literal records but I am having a hard time making a useful application that does not mirror a DB record. 

1) given 

--- form PERSON

known by ID

has Last Name

has first Name

--- form COUPLE

lookup PERSON.ID for man

lookup PERSON.ID for woman

Now when I build the COUPLE form I want to use a reference of ID back to PERSON twice, but I can only fill a drop down list with abstract IDs.  I want the drop down to shown the names (First, Last) but then once I select I want the ID to go in to the DB.

The above comes from the not being able to specify the keys for a form(table).  Either need to be able to specify the key to a file or when pulling in a ID reference you need to be able to search by  something meaningful. Is there a way aroudn this?

2) I do not see any way to do something like an EDIT/EDIT_DETAIL.  This is I would like to be able to enter a record key and then enter multiple entries of details for that key.

The typical example is  ORDER / ORDER DETAIL.  I could have a list of orders - each having information about the order itself and each order having N order detail records. The idea is that one needs a simple way to enter an ORDER and its DETAILS.  And, a simple way to list the orders and by selecting an order then show the details for a given order.

Does anyone have an example of either of the two issues above?

Thanks,

John