the language is vb.net, but it is more of a mysql database question.
I have a table that holds customer repair information (where it is, whats going on, if it was completed, etc).
the table starts with a basic auto increment ID, the id is used to view the repair information associate with a customer_id (from customer table, not relative)
lets say a customer has two repairs in the system, and wants them put together and only called when both are complete.
what is the best method to link these repairs? (keep in mind he could have anywhere from say 1-10 repairs that they might want linked together)
should i create a seperate table that links the repair ids, or create a column called linked that holds the repair ids that it is linked to?
1.001, 2.001, 3.001
i am not exactly sure the best method to go about this, would like some input