automatic hyperlink

[Guest]

Question:

Field: "275 230-311-01 A" is a hyperlink field to a spesific drawing in my
table.
Is it possible to make this hyperlink "automatic" by putting together the
other fields in my form?
The filename of the hyperlink contains build no, drawing no and revision no.
If anyone could help me with this it would make my day much easier.

 

[Guest]

Hi

Sorry but I don't understand fully what you wanting to do.

Are you wanting to send your drawings/revision after a certain event/action
to someone by email.

 

[Ron2006]

You can consturct a "field/variable" by concatenating the parts.
example

me.filename = me.buildingnumber & me.drawingnumber &
me.revisionNumber & ".jpg" or whatever.

if spaces or dashes needed then something like this will work:

me.filename = me.buildingnumber & " " & me.drawingnumber & "-" &
me.revisionNumber & ".jpg"

Ron