How Do I Attach A File To A Form

[HappyBunny]

Hi.....Im trying to learn how to attach a file to the form....The idea
is, the user can not only add a record but will also be able to add an
attachment for that particular record....lets say I would like to add
an excel or word doc...this has nothing to do with sending attachments
and emails and stuff like that...just attaching a file to the form...

 

[sd100]

I've done this in quite a simple way...

I' added a text field for each client on my Client table. Then I made the text box into a hyperlink via properties. You have to use admin mode to edit the hyperlink, which does have to be done for each client but you only need to set this once. The location of each client's folder is then stored in the text box / field on the Client table, so the hyperlink takes you to a specific location for each client.

Hope this helps

 

[missinglinq]

You don't mention what version you're running, and sd100 may be the best solution. Version 2007 actually has this capability built in, although Allen Browne, in his The Good, the Bad and the Buggy, puts it in the "mixed good and bad" category, noting that attachments are complex data, and hence are difficult to manage, and that many large attachments may push you towards to 2GB limit.