hi im trying to make a report with info from 2 tables those tables have related fields, what im trying to do is to make a inner join, i mean have a report with info from those two tables

in another hand i want to make a report asking for a values with in a list a then look in those tables to show the result, is that posible?

i dont know how to add scripts, do i have to added to a button or how i define it?

any one can help me, im new in this fm

thanks

Hi alvariux

I see that so far you have had no response and I suspect the reason is that your question is a bit too vague. It is certainly possible in a report to show information from two or more related tables and similarly specify what information is shown but without some more detail I don't think you will get any help other than general answers such as I am giving you here.

Regarding scripts you can turn any element in a layout into a button or use the button design elements provided in FM7. You can attach a script to the button or just a single operation (like New record), this is contained within the formatting options for a button.