Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue related to triggers


Hi all,

I am facing a scenario related to trigger.  In my report i have data from two tables Sales and stcok. There is no relation between them.

I had created a report which had data for sales and stocks for monthly and annual basis.

For doing the same, i had created two separated inlines.

> for sales , Reporting time frame , Reporting time frame no

> stcoks , Reporting time Frame1 , Reporting time frame no1

Now as per the new requiement, i have to show data for stocks and sales simultaneously. I created a new inline for doing the same. Time frame , Time frame no.

But i am not able to connect the time frames from sales and stock with new inline. Even if i am using triggers. Not able to connect data of two tables.

Trigger used on field Time frame is select in field.

Please suggest how can i achieve the same i.e if i make any selection in new inline like monthly then corresponding fields in sales and stock must be selected.

3 Replies
Jason_Michaelides
Luminary Alumni
Luminary Alumni

Why can you not connect the two tables using "Time frame"?

Not applicable
Author

Actually there is no relation between two time frames. we had created the time frames using flags in both the tables.

Jason_Michaelides
Luminary Alumni
Luminary Alumni

OK.  Can you post a sample app please?