expanding popupRecord
from a button script --- opening another table record from another table form is great where I know the id of the other form I want to open.
ie popupRecord(record(Quotes,72)) “opens record ID72 of ”Quotes“ table
However do not want to a form by its ID i want it to open by. sepcific field with the Quotes form ie ”QREF“ the quote refence number
so I know I need to copy the Qref from my current form
let xCopy := ”Qref“;
popupRecord(record(Quotes,xCopy) -- does not work because it is expecting a record !! how do i change to find the recods that has the matching QREF
Then grab that ID or simply open it by the QREF field?
2 replies
-
with a select statement you can do that.(this gives back a ID)
e.g.
let xCopy := “Qref”;
let i := first(select Quotes where Qref = xCopy);
popupRecord(i)
Steven
-
Cheers Steven - Works a treat :-)
Content aside
- 4 yrs agoLast active
- 2Replies
- 466Views