Forum Discussion
All I need is to be able to choose a car from the customers list of cars
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.
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.
Nothing to apologize for I'm grateful for your help. Thank you so very much for your reply.
I've Deleted the AutomobileID from the OrderT but I'm still getting multiple cars, should I create a new combo box or listbox to the editied OrderT? Thank you again so much, I'm new to this so all of your help is so appreciated.- I'm sure George did not mean "delete the AutomobileID from Orders". If you did that, how would you know which auto the order is for? He meant "do not store 0, but the actual AutomobileID.
And while you are at it: remove the default on Orders.AutomobileID, and set the field to be required. After all, all orders must have an auto associated.- I'll be doing that now, and I have backups so going backwards in time is no problem. I'm an old guy still learning new things and I'm appreciative of all the help I've gotten from you all.
