image on form

ervaroervaro Member Posts: 17
Hi,

I have read some topics about this subject but can not find what i am looking for :(

Here is my case.
Besides the Item table I created an extra table called Item Picture. The last mentioned table has only two fields (Item No. and Picture) and is used to store pictures of items. This is done to avoid any performance issues with the BLOB-field in the Item table. Now I want to show the picture from the other table on the Item card. Therefore I added a picturebox.

From then it is not clear for me. The next questions came up.
1. What is the SourceExpr for the picturebox? Is it Picture from the Item table or a global or something else?
2. How do I exactly get the BLOB into the picturebox?

Any help is appreciated.

Thanks.

Erik

Comments

  • cifcif Member Posts: 6
    Hi,

    two ideas:

    1) create a new form with a picture box for your new table and add it as a subform to your item card
    You may copy the existing form from the NAV standard.
    2) create a record variable for your new table in item card. OnAfterGetCurrRecord get the record and CALCFIELDS the BLOB. Place a picture box on the item card and put "record.blob" (replace by real name) to the SourceExpression.

    Hope this helps.
  • ervaroervaro Member Posts: 17
    This is what I was looking for.
    Thanks for your reply.
Sign In or Register to comment.