Relation between table

(0) Share

Report

Posted on by fajar

3,805

In form ProjProjectListPage i can see button Attachments in tab Project.

So, if i click button Attachment and select one file until finished, and then i see in table DocuRef, i can see relation and get link between table DocuRef and table ProjTable.

Now, i want to add button Attachment in form Hierarchy with table smmActivities.

So, if i click button Attachment in form Hierarchy i can get relation and get link between table DocuRef and table smmActivities.

What can i do?

What methods i use?

Thanks all..

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Amir Nazim 5,994 on at

Like (0)

Report

you can add similar relation to this with DocuRef table using smmActivities table. check the DocuRef table for more examples.

DocuRef.RefCompanyId == PurchTable.dataAreaId

DocuRef.RefTableId == PurchTable.TableId

DocuRef.RefRecId == PurchTable.RecId

Was this reply helpful? Yes No
Jonathan Halland 11,310 on at

Like (0)

Report

Hi. I don't believe adding the relationship is absolutely necessary. Just add a command button to your form with the command property of the button set to "Document Handling".

Was this reply helpful? Yes No
fajar 3,805 on at

Like (0)

Report

Thanks all.. I will explain.

First time, i add relation in table DocuRef.

DocuRef.RefCompanyId == smmActivities.dataAreaId

DocuRef.RefRecId == smmActivities.RecId

DocuRef.RefTableId == smmActivities.TableId

And then in modul Project management and accounting, select one Project --> Tab Plan --> Work breakdown structure.

I have one Activities, A14-01275

i click Activities Sample and then click button Attachment.

Click New and select file, i select file "Sample Doc 1", finished.

And then, i try to open table DocuRef and table smmActivities.

In table DocuRef with Name "Sample Doc 1" and RefRecId "5637149077"

In table smmActivities with Activity "A14-01275" and RecId "5637155826"

Different between DocuRef.RefRecId == smmActivities.RecId,,, why ?

What wrong? or what can i do?

Please help me..

Thanks..

Was this reply helpful? Yes No
Suggested answer

Amir Nazim 5,994 on at

Like (0)

Report

As the grid datasource is bound with Hierarchy table, so It will be saving the attachement with reference of Hierarchy table instead of smmActivities table.

Was this reply helpful? Yes No