OLE Object - auto link?

[Shaun Allan]

I want to have an OLE object field that shows AutoCAD
drawings, depending on the drawing number. I can manually
do the link, but is it possible to do this automatically?

The link to a drawing takes the form of :
c:\drawings\[BLOCK]\piping\[ISONUMBER]a.dwg where BLOCK
and ISONUMBER are both fields on the form (the rest of the
link is standard throughout). Can I create the link
(SOURCEDOC?) to a drawing by code or something so it will
automatically show the correct drawing, or will I have to
do it manually for each of the 3000 records?

Thanks in advance.

 

[B. Macdonald]

Yes you can do it automatically. I know it can be done
with a Macro but I can't tell you the syntax. I want to
do the same thing with images myself and will be watching
for the answer.

I am able to do it on my web site, by using C# to refer
to the url in a text field.

I know this isn't much help.