It will display the CustomerID in the CustomerID field, but the CustID doesnt match the ID in the orders and it doesnt link the correct personal info to the order info.
BillyBob Thorton wrote:...I need to be able to select a CustomerID from the Java GUI and then that will display the personal info from the Customers table and also the Order history from the Orders table that corresponds with the ID...
BillyBob Thorton wrote:Should I be having a customerID field in each Customer and Orders table to link them? Right now I have a CustomerID in Customers Table that is supposed to link ID field in the Orders Table, not sure if this is appropriate set-up or not.
So say I select CustID: #2 from the drop box. Instead of displaying CustID #2 it will display CustID #3 Personal Information and with that CustID it will link to ID: 3 in the Orders table and display that correct Order info..