How to link folders to libreoffice base

[markus]

Similar to linking images locations to database. Is there a way to link folder to a row in a table.

For example,
Suppose we have 3 tables as follows.

1. Documents -
   DocID DocName

2. DocumentVersion -
   Date DocID DocVersionName Remarks

3. DocVersionFeedback -
   Date DocVersionName DocFeedbackID Remarks Doclink

   Where Doclink is link to folder where the documents is stored in computer.

Now when a record is entered in DocumentFeedback table can we do the following

• First to create a folder suppose ( c:\Documents\DocName\DocVersionName\DocFeedbackID ).
• Second open the folder so that the feedback file can be placed in the folder.

By doing this we can directly access the files in the folder from the LO(libreoffice) base.

is this possible in LO base. Please guide me.

Regards,
Markus.

[markus]

hi all,
I have done some research online and found there is an option of opening a folder in explorer from form in MS access.
here is a link for that
link text
link text

I think the same can be done in LO by using macro.
can any one guide me. I have not much experience coding marco’s.

Regards markus.

[iplaw67]

Please read Roberto Benitez’ book :

http://www.lulu.com/shop/roberto-benitez/database-programming-with-openofficeorg-base-basic/paperback/product-3568728.html

which should point you in the right direction, or at least indicate whether this is possible.