AnsweredAssumed Answered

Relationship or ExecuteSQL

Question asked by raphthepenguin on Mar 13, 2014
Latest reply on Mar 14, 2014 by raphthepenguin

Hey there,


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

Unfinished transactions

Contact reminders...

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?


Thanks alot,