Member Avatar for mazintech

Hi
i need assistance on how i can pass a value from a table to update the other table for example.

VehicleDetailsTable with Fields ( Milage, Description, RegNumber etc) VehicleMilageTable with fields ( Regnumber StartingMilage, Endingmilage etc) EndingMilage is used to update Milage in VehiucleDetailsTable.

  • 2 Contributors
  • 1 Reply
  • 81 Views
  • 2 Months Discussion Span
  • Latest Post Latest Post by G_Waddell
Member Avatar for G_Waddell

Take the relevent fields from one table and pass into an insert statement to run on the other one...

Perhaps if you show what you have tried so far we can give help and guidence

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.