I am having a Database tracking of, Activity, Transactions and so on...
I would like to integrate a new Reminder layout, that on open reminds the user of:
Soon Inactive and Inactive people
and anything else that needs reminding!
With that I would like to have a checkbox, so people can cross of lits of the reminder page.
I have already made reminder status fields (like one that says "Inactive" for the record).
Now we come to the actual question. I was thinking of relating the Layout to all the other ones, and then show the records in several portals.
But I also have read alot about the ExecuteSQL function and it seems like, if someone knows what he is doing this will be a quicker and easier approach, with less possible error.
How would I display the Function result on my layout? Will i still be able to have a checkbox, or will there just be an uneditable list?
What would you recommend?