0

Update a field in another table

Hi,

I have a 'Parts of car' table, where after selecting for example the engine, I need to select the parts (in this case 1 part) which is necessary to repair the engine.  I have to enter a number here for this part, for example, I need 9 pieces of this part. I have another table Maintenance that contains this Part and a TotalUse field. I now want to add the Quantity from the 'Parts of car' table to this TotalUse field in the Maintenace table. How do I do this.

Tx

Regards

Michel

1 reply

null
    • Fred
    • 10 mths ago
    • Reported - view

    Can you specify the relationship between Parts of car and Maintenance? Is it a 1:N or N:1 or even a N:N?

    or

    Can you post a sample of your DB?

Login to reply

Content aside

  • 10 mths agoLast active
  • 1Replies
  • 82Views
  • 3 Following