Using a Page
Hello
I have a table with my billing in different currencies.
I have created a page where I want to graph my sales in Soles (Yes, I am from Peru).
On the page I have created a field where I put the exchange rate of the day; 'T.C.'.
When calling my billing table using select 'Billing', it no longer lets me use the 'T.C.' field.
How can I do this?
Thanks for your help
1 reply
-
I am not sure how you want ti use it in your view but
You will need to use a variable to to store the value for T.C.
Then reference it in your select query depending on what your query is intended to do
is like one of my examples
on the form i have a filed called Company search
thus I have declared a variable - myRef
in the query on the table view I have
let myRef := CompanySearch;
do as server
select Contacts where Customers.Company like myRef
end
Content aside
- Status Answered
- 1 mth agoLast active
- 1Replies
- 43Views
-
2
Following