Open form from Table Frame view with mouse double click
Open form from Table Frame view with mouse double click
(OP)
We would like to view our database in a table view form. When we find a record of interest we'd like to double click on the row for the record that opens a form view of the record to get to all the memo fields and child table info as a table frame to the parent record.
i.e. view customers in table frame view. Double click customer of interest and new form with address, etc in a form view and on the same form is a tableview of that customers orders.
Thanks,
Bill
i.e. view customers in table frame view. Double click customer of interest and new form with address, etc in a form view and on the same form is a tableview of that customers orders.
Thanks,
Bill
RE: Open form from Table Frame view with mouse double click
You can't attach code to a tableview.
Is that your question?
Or are you talking about a tableframe on a form?
Tony McGuire
"It's not about having enough time; we have the rest of our lives. It's about priorities."
RE: Open form from Table Frame view with mouse double click
var
frm form
orderNum number
tc Tcursor
endvar
orderNum=custorder.value
if isedit() then endedit() endif
tc.open("Temp1")
if orderNum.isBlank() = false then
if tc.locate("custorder",orderNum) then
if tc.qlocate(orderNum) then ; use qlocate if client # is the primary key field, much faster.
frm.open("orderentry")
frm.custorder.movetorecord(tc)
;frm.custorder.setRange(orderNum) ; use setrange to keep the user from moving off the record
else
MsgStop("Error",ordernum.string()+" "+"Is Not a Valid Number")
endif
endif
endif
tc.close()
Lewy