I don’t know if I ought to give up & quit, which I don’t easily do. I’m still struggling with my make-shift car dealership dbs. I try to follow the rules of Normalization, yet I can’t get these Tales to relate for me no matter what I try
I have the following 5-Tables:
1. Customers Employer- (customers employment info – address, contact, etc)
2. Customers Employment- (Where the customer works/position, DateHired, & MonthlyIncome)
3. Customers Finance- (how much is the vehicle, DownPayment, & MonthlyPayments)
4. Customers Info- (Customers’ contact info)
5. Sales Rep- (Contact info, commission, DateHired, etc.)
6. Vehicle Inventory- Vehicles info)
There are a few things I would like to do, but I don’t know how to relate these Tables to achieve my goals as followed:
1. I want to see both the ‘CustomerID’ (related to my Customers Table) & the ‘SalesRepID’ in my Inventory Table.
2. I want to know how I can entered a ‘CustomerID’ just once & have it reflect (I don’t know what word to use here) into ALL of my other Tables. Ie. If I enter a ‘CustomerID’ in my Inventory Table (when a customer purchases a vechicle) then I would like to have that “CustomerID’ be in my Customers Info Table, Customers Finance Table, as well as in the Customer Employment Table.
I ought to only have to input the ‘CustomerID once, but I’ve spent a week trying to figure out how it can be done. Note, I’ve had help from many people here on this forum regarding this post, but I’m starting ALL over from scratch & just REALLY REALLY struggling!!!!!!
I’m not asking anyone to do my work; just some re-direction starting from scratch.