Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Why can you not connect the two tables using "Time frame"?
Actually there is no relation between two time frames. we had created the time frames using flags in both the tables.
OK. Can you post a sample app please?