How to get the Main TableForm From Another Form

I Am create 2 tables Table1,Table2

and also created forms for the table1,table2 as Table1form, Table2form

( Added these two forms into Menu item Display tab)

i created areation between these 2 tables by using EDT level normal relation

and i gave the Table1form as the Formref to Table2

now i opened Table2 From Right click on the related field column → Choose GO TO Maintable form

but i didn’t get the Table1 Form . it’s opening same form why ?

how to get the table1form ?

(I Am also tried with table level normal relation but i didn’t get output. y?

After Adding the form1 into an MenuItem i am getting an error message while click on GoToMaintable8203.Error.jpg

Y The error messge coming…?

Any one having the idea…

HI Roshan,

You need to mention the FormRef property on the table1…

You can get look up in many ways - by using an EDT with relation (or) form ref property (or) by putting some code using the SysTableLookup class

this link may help you http://www.axaptapedia.com/Lookups

I mentioned in the table2 FormRef → Table1Form

i want table1form form the table2form

how can i get it?

Hi Roshan

When you open the Table2Form and GotoMain table – Table1Form

then need to mention the ‘table2’ — FormRef property as menuitem of ‘Table2Form’.

Thanks for u r reply…now i got the Solution…

but some confusion

Hi Roshan

When you open the Table2Form and GotoMain table – Table1Form

then need to mention the ‘table2’ — FormRef property as menuitem of ‘Table1Form’.

To Naresh Kumar Kolli,

Thank’s for u r reply…

To Naresh kumar,

I mentioned in the Table2 → Form ref–> choosen table1form

Now aging i have to choosen the Table1 → Formref → Table1Form

Now i got the solution…

is it nessary to mention Table1FormRef → Table1Form

Let’s take a example

In SalesTable There is no FormRef

In the SalesOrder Form when i choose the GoTo Main Table From customer Account Field

It opens CustDetails Form where the relation is established ?

Hi Roshan,

That is because of relation at ‘extended datatype’ of the ‘CustAccount’ .

Just check with this,i think u have created the table and the form… add the custAccount edt in one of the table and also in the form… Open the form and check the custAccount it will go to the custTable form…

To Naresh Kolli,

In the same way i am created a EDT (Relation) and assign the same EDT to 2 fieds

one field is in table1 & another one is in table2

It shows me a drop down box but when i choose the Go To main table ( there is no table level relatio here)

it won’t take me to the table2form to table1form until i filled the properites as

Table2 FormRef → as Table1form

Table1 FormRef → as Table1form

Why it is happening…?

NO need to give the relation between the two tables. Create an EDT → with relation EDT == Table1.column

use the EDT in the table2 add the field to table2from now when you do go to main table for that field in the table2 form then actually it will take you to the table1From (Modify the name of form table1from to table1(which is the the table name) and try)…

Thanks kranti…

i changed the form Name & I got the solution…

Create a EDT (Relation) and assign the same EDT to 2 fieds in the two tables

one field is in table1 & another one is in table2

It shows you a drop down box but and GoToMainTable,but not require any table level table level relation

Until and unless you specify the FormRef property for the it wont go…