thunderstorm
Registered User.
- Local time
- Today, 08:03
- Joined
- Jan 16, 2004
- Messages
- 18
i have 4 tables in my db, customer, car, invoice and tyre.
a customer has their car fitted with new tyres, and the db is used to store their car info and tyres fitted and personal details.
i can make a form with the car and customer info together so i can enter it all at once fine. but if i want to add on the tyre info for each customer it doesnt seem to work maybe my relationships are wrong?
these are the current relationships (one > many)
Customer (customer ID) > Car (customer ID)
Customer (customer ID) > Invoice (customer ID)
Tyre (Type of Tyre) > Invoice (Type of Tyre)
ne one know what could be wrong? thanks !
a customer has their car fitted with new tyres, and the db is used to store their car info and tyres fitted and personal details.
i can make a form with the car and customer info together so i can enter it all at once fine. but if i want to add on the tyre info for each customer it doesnt seem to work maybe my relationships are wrong?
these are the current relationships (one > many)
Customer (customer ID) > Car (customer ID)
Customer (customer ID) > Invoice (customer ID)
Tyre (Type of Tyre) > Invoice (Type of Tyre)
ne one know what could be wrong? thanks !
