Representing primary/foreign key relationships between recor

Representing primary/foreign key relationships between recor

Hi there.

I am a newbie to Zoho creator, but somewhat familiar with programming/databases.

I want to create some pages that (effectively) represent a primary/foreign key relationship in a relational databases.

Specifically what I am trying to do is something like:

form1:
---------
field1
field2
field3 .....
< I understand from other posts, that this form will also have a hidden filed - ID - which is a unique id for a given record )
(Note also that in my app, the logical primary key for this form is the combination of field1 and field2)


What I then want to create is Form2, where multiple records from Form2 can reference a single entry from Form 1.

To the user, the ID field is meaningless. What is meaningful to them is to display the string: $form1.field1 + " " + $form1.field2

What I want to do is to include a mechanism (from what I can see, picklist is the most appropriate option), where the user can choose an entry (eg the string: $form1.field1 + " " + $form1.field2 ), but have the corresponding record ID embedded in the record (essentially all I am trying to do is to give form2 the foreign key: primary (ID) key of form1, but also giving the users a search list the is meaningful to them).

I would appreciate any assistance you might be able to offer.

Cheers

guest7