Enrollment Database- Multiple customers, same order.

[nate]

I need some creative help here,

I have an enrollment database, which currently enrolls students through an order form, (that is we choose the student, the class- which lists the price, etc...). This is put onto an Orders Table, and an Order Details ID table, tblOrders has the detail of the whole order and tblOrderDetailID has the individual products they ordered, or in this case, the classes they enrolled in.

I'm looking to redo some aspects of it, and one of its biggest downfalls are that we have to enroll students individually on the order forms, so if we get sibling students, their orders (and thus their recorded payments and discount) are recorded separately.

I'd like a way to have an order form where I could have multiple student enroll under the same OrderID, but I cannot think of how I could make this work. Does anyone have any ideas for the table structure that would be best, or perhaps a suggestion for a better way?

 

[statsman]

I can see a number of problems with what you are trying to do.

As each student takes up one space in the class, trying to enrol multiple students with one ID is going to cause you any number of problems with class size etc. In addition, if you use groups instead of individuals, who is paying and what do you do if a student "drops out" and wants a refund.

If your current system is working well, I would leave well enough alone. There may be some data entry headaches, but I see your proposal creating more problems than it solves.

 

[nate]

It does work well, and I suspected it would be difficult to do anything otherwise, but thanks for your help.