Links on Fields on Forms

When we open the form.There are some fields which are like hyperlinks and when we click on these
fields a new form is open.

As you can see the example below just go to the Account Receivable->Customers->All Customers.
The new form will open with fields cotaining the hyperlink.

And when I click on this field a new form is open as you can see in the below image.

 

 

 

Basically these fields physically exist in other table and they are showing on this table through foreign key.

 

The question is how the form is open when we click on these fields.The simple answer is that to open the form on this field just go to the table in which this field actually resides and than in the property of that table set the formref=formname.

Now The Query that shows the data on the Preview Pane is "CustListPagePreviewPane".In that Query there is table i.e custtable which uses that field i.e "CustGroup".Now we will go into the relation of that table to show that what is the parent table in which this field actually exist.

You can see the image of the custtable in the below image.























Now we will go to the property of the table CustGroup and see the FormRef propery.

As you can see the name of the form in the formref property.This is the form which open when we click on the link custgroup.

Thanks