Please Help

[Baodekker]

Hi guys,

I have almost finished my little database (somehow) but i am stuck on one last problem which i just can't seem to figure out.

It's probably way to much explaining so i thought i might just upload the database here (it is only small) and see if anyone would take a look at it.

Basically what i would like to do is, in the 'profits' table i would like all the fields to auto-calculate the sum of money based on the 'bookings' table. The reason i am uploading the database is because i would have to explain all the relations and i am sure, although it works i have done it wrong haha

any help would be greatly appreciated

Thanks

Booking.zip

[Søren Dyhr]

My eyes might be blurred, but where is the login/password menthind in your text?

--sd

[Baodekker]

Doh!

Sorry

Admin

251879

[Søren Dyhr]

First thing that strikes me is the use of price as relational key, are they under a divine demand fixed for eternal use? Is this some sort of filtering based on what the person can afford?

Why does the booking not come as a join table between course and attendee? Does this mean if a person should need more courses, their record simply are duplicated - and the previous choice is then changed.

There is no need to establish relationships to build value-list unless they need to strain, on say previous choices made or avialiability - is this what is attempted via the complex selfjoin structure.

--sd

[Baodekker]

Please excuse my late reply.

In regards to all your questions, i have no idea! haha as i said above, it works but i am sure i have done it wrong. this is my first attempt at any form of database so i am a complete novice.

I think you get the idea of what i'm trying to do though right?

[Søren Dyhr]

I think you get the idea of what i'm trying to do though right?

I'm unfortunately far from, since the home brewed approach to relations gets severely in the way ... what about telling us the context and purpose of what you wish to achieve instead.

--sd