sayedsohail Posted July 16, 2007 Share Posted July 16, 2007 Hi everyone, I am trying to create a table design where i can store predifined titles and the other table to store the contents-service logs under the selected titles. table 1 name:titles Fields: title_id tiny int autoincrement title_desc varchar 45 not null table 2 name: service id int autoincrement car_id int title_id tiny int -> service_desc text date_service date In table 2, most of the times i am storing multiple service logs for the same car i.e, if a car comes for a service in a garrage i am storing multiple records under different titles, i.e, oil filter, engine oil. If a car comes for second service, than i am storing multiple records again under service table, which i can identified by the date. I am not sure if this can be improved, any advise would be greatly appreciated. Thanks for reading. Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.