Creating a Table/Report

[spam33]

Hi,

I am creating my first FM Pro database, but I am kind of stuck. Here is a basic overview of a file.

The file has two fields, Film Name and Year. I want to create a report that will list each film and its year, and then place a delete button next to it that will give me the option of deleting the film.

I have been able to create a report (using the wizard) that has the films and year, but I just cannot set up that darn button. I can draw one out in Layout mode and give it some properties, but it just will not appear in Browse mode. Can anyone give me some advice on how I can do this?

Thanks.

[andygaunt]

Hi, first make sure your layout is set to view as a list.

Now, draw a button in the body area of that layout (next to the fields) and choose delete record/request option (found under the records commands)

Now, when you browse the layout, you should see your data in a list format, with a button next to each record. Now when you press the button you will be asked if you are sure you want to delete (why? Because we did not turn the option off on the button. If you do not want any warning, then simply go back to the layout mode and double click the button, then in the options, check the Perform without dialog)

HTH