I have 2 tables joined in a one to many.  I want to change the values in
the 2nd table depending on the value of a field in the parent, and I
dont know how to do that.

I can SHOW the records in question with a SELECT statmeent:

  SELECT Patient.Balance,
         Patient.LastName,
         Tcharges.T_link,
         Tcharges.T_billpatient,
         Tcharges.T_billinsurance
    FROM "C:\z24\GAIL24\pbsw24\data\patient.dat" Patient
         INNER JOIN "C:\z24\GAIL24\pbsw24\data\Tcharges.DAT" Tcharges
                 ON Patient.Acct = Tcharges.T_acctnum
   WHERE (Patient.Balance = 0)

How do I do the UPDATE command?

Jerry Blumenthal

Jerry,

<< I have 2 tables joined in a one to many.  I want to change the values in
the 2nd table depending on the value of a field in the parent, and I dont
know how to do that. >>

It's similar to the SELECT:

UPDATE "C:\z24\GAIL24\pbsw24\data\Tcharges.DAT" Tcharges SET <Set values
here>
FROM "C:\z24\GAIL24\pbsw24\data\Tcharges.DAT" Tcharges
INNER JOIN "C:\z24\GAIL24\pbsw24\data\patient.dat" Patient ON Patient.Acct =
Tcharges.T_acctnum
WHERE (Patient.Balance = 0)

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks Tim. I really appreciate the help.
Jerry


Tim Young [Elevate Software] wrote:
> Jerry,
>
> << I have 2 tables joined in a one to many.  I want to change the values in
> the 2nd table depending on the value of a field in the parent, and I dont
> know how to do that. >>
>
> It's similar to the SELECT:
>
> UPDATE "C:\z24\GAIL24\pbsw24\data\Tcharges.DAT" Tcharges SET <Set values
> here>
> FROM "C:\z24\GAIL24\pbsw24\data\Tcharges.DAT" Tcharges
> INNER JOIN "C:\z24\GAIL24\pbsw24\data\patient.dat" Patient ON Patient.Acct =
> Tcharges.T_acctnum
> WHERE (Patient.Balance = 0)
>