Hello to all,

I'm finishing the design of a FM database that holds hotels, prices and services. One of the fields has to hold an image of the hotel. As there are hundreds of hotels to be feeded into the database, I've created a button to insert an image into the field. It worked a few days ago and doesn't anymore. I tried several solutions but must be missing something. Even when I transform a container field into a button with the "insert picture" function, it doesn't work either.

I know this is a very basic question, and I'm sorry about it, but it gets me very angry as I've managed to put together the whole db with currency calculations, scripts and am stuck with this... stupid... basic... aaaaargh!

Mark

Edited August 4, 200718 yr by Guest

It has to Go To Field [ container field ] first, because the Insert commands don't specify a field. So, by defining the field on the layout as a button stops it actually going to the field (the button action does not recognize the field it's attached to, a common misunderstanding).

Create a script that goes to the field first, the run Insert. Then you should be able to attach the script to the field.

Thank you so much Fenton. Just managed to do it, really don't understand how it could work yesterday, but I probably was importing the picture directly to the layout, not to the database.

Cheers,

mark

Hello to all,

I had help from this forum to setup a button to insert an image in a container. I'm trying to make a second button to erase the same image from the container but the only command I found is Erase record/request which of course erases the whole.. uh... record.

I couldn't find an "erase field content" command.

Is there another way to do this?

Thanks for the help.

Mark

Either:

Clear [ Container field ]

or

Set Field [ Container field; "" ]

then

Commit Record

Thank you for your help.

I'm in such a hurry with this db that I'm starting to overlook things. It was obvious after you told me.

Mark