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,

 

Raph

Outcomes