Paradox form question 1

[jjam64]

I work in a law office and I have created a database for tracking legal documents. I have created a main database table with a form based on that table. I have also created another form using fields from the main database table that we use as data entry forms. These secondary forms are accessed by a pushbutton. For example, when we file a document, we have a form that shows all applicable fields that need to be filled in. Both forms have a court docket number that we use to search for a specific record. I would like to be able to search for the docket number on the main database form and when I click the button to bring up the form for filing documents, that form will already be on the docket number that I searched for on the main database form. Can anyone tell me if there is a way to link both forms on the docket number field so that only one search is necessary? Or is there any way in which I can do this? Both forms are created on the same database table. Thanks!

 

[TonyMcGuire]

Off the top of my head (NOT TESTED):

var
frm form
endvar
stDocket=current_form_docket_field.value
if isedit() then endedit() endif
frm.open(":aliastherform.fsl")
frm.locate("docketfield",stDocket)

You could also write to an environmentstring from the main form, and have the form you are opening do a locate (qlocate if keyed field) on the docket field based on that environmentstring value.


Tony McGuire

http://www.thedbcommunity.com

"It's not about having enough time. It's about priorities.