Forum Discussion

NINER11's avatar
NINER11
Copper Contributor
Jun 10, 2023
Solved

All I need is to be able to choose a car from the customers list of cars

I've designed a database for an auto repair company and everything works great except for one issue with the invoice. The autoT Table is set to a customer in the CustomerT table, and in the AutoT Tab...
  • George_Hepworth's avatar
    Jun 11, 2023

    NINER11 

     

    Sorry it took so long, but I finally figured out the problem. You do NOT store the automobile ID with the Order for work on that ID. All of the foreign key fields for AutomobileID in the Order table are 0.

     

    I was struggling to figure out why none of the usual methods worked, and as a last resort "looked at the data". LOL.

     

    Lesson re-learned. Always start with the data when problems arise.

Resources