Hello All!
I hope you had a happy new year!
Sorry to be a pest, but I just am not getting the synch stuff
figured out. Here is what I want to do.
The calling form is a multi-table form that has a Mousedouble
function tied to the Customer Name field. What I envision is
that my user will doubleclick on the name field, bring up a
dialog box, locate the customer they want to be working with,
or discover that the customer does not exist. If the customer
does not exist, I want the user to be able to enter the data
in the dialog box, and then return to the calling form, with
the correct record now inserted into the proper fields.
The calling form has the customer.db fields plus data from
two other tables that are all linked using referential
integrity based on the Customer.Name and Customer.Custid
fields. The Custid form is an auto-increment field if that makes any
difference.
I created a dialog box form for my work::Customer.db table
On that form I have the Customer.db fields
Name
CustId
Address
Address2
City
State
Zip
I replaced the Name field with a drop down edit list that is
populated with the Customer.name field using Self.DataSource.
Also on the form I have two buttons
Okaybutton
the pushbutton method here has:
formReturn("OK")
Cancelbutton
the pushbutton method here has:
formReturn("Cancel")
Now What I want to do is two things...
First:
on the form synch the rest of the fields of the Customer.db
to the drop down list so that when I move off the drop down
list, the correct custid and addresses for that record are viewed.
Second:
When I press the OkayButton... I want to pass the current
Customer Record back to the form that called it.
So what do I need to do to accomplish the above?
In terms of code added to the calling form mousedouble method?
In terms of adding stuff to the dropdown edit list?
In terms of adding stuff to the okay button.
I know that I have to add stuff in all three places to make this all work,
plus adding code to CanDepart perhaps on the list field...
When I have tried  tableframe.record.field.locate(x,listfield.value)
I got a syntax error message I did not understand.
I have not attempted all the stuff in your last message totally. Got error
messages when I added the close(string("customer.db".lookupvalue) to the
Okay buttton.
Is there a TI doc that Borland puts out that documents any of this stuff?
David
--- GoldED/386 2.42.G0614+  Zyxel 19.2
---------------
** A related thread FOLLOWS this message.

FIDO MESSAGE AREA==> TOPIC: 119 PARADOX       Ref: C1ED3444 Date: 01/10/95
From: STEVE BOOTH                                           Time: 09:57am
\/To: DAVID BAIRD                                         (Read 10 times)
Subj: R: ObjectPal Dialog Method?

David,
   The easiest way to transfer info between forms that I've found:
 
   Form1
      frm2hndl.open("Form2")
      frm2hndl.wait()
      x = frm2hndl.Table_Rec.Value
 
   I've also found that casting data sometimes helps on the locate without
overly qualifying things.
 
   I'd also look at trying to place common code into a method or proc and
have all the routines call it as much as possible.
 
Just a few thoughts....
 
Regards, STeve... (Exec-PC Netmail: 1:154/280)
---------------
>>>>>>>>>>>>>>>>>>>>>> LAST Message In Thread <<<<<<<<<<<<<<<<<<<<<<

FIDO MESSAGE AREA==> TOPIC: 119 PARADOX       Ref: C1D00001 Date: 01/06/95
From: TERRY MCGRATH                                         Time: 07:42pm
\/To: TOM DARRAGH                                         (Read 9 times)
Subj: Report Calculations

* In a message originally to All, Tom Darragh said:
 TD> Is it possible in a report to control the display of data
 TD> in one
 TD> calculated field based on the data in another field. My
 TD> situation is
 TD> this:
 TD> I have a report that is based on an answer table of a
 TD> query. The report
 TD> I want the "total amount" field to display its calculation
 TD> only when the
 TD> "shipping" field has data in it. I tried to use the iif
Try IIF(NOT ISBLANK([Shipping]),STRVAL(calc),"") That will change the field 
type, but it will display the correct data. Hope this gets you in the right 
direction.
Terry McGrath
---
---------------