How to Insert values in RecordID (Table name record Link)

gopinathabs

Dear All,
I need to insert the value in Record Link Table while creating invoice automatically.[In SQL Database, Nav 5.0]

I able to insert all fields in Record Link table except RecordID field through coding.

send me the sample coding how to insert the New lines in Record link table

Note:I need to tag only one pdf to all the invoices which is already tagged in another table..

.

ara3n

Are you inserting the data directly from SQL?

If you are doing from NAV you can use the function.
record.ADDLINK(URL [, Description])


If you are doing it directly from SQL. then the logic is basically TableName: Primary Key Field1,Primary Key Field2