Please please help

[David.Poundall]

You get the same problem when trying to delete. To many interrelated tables. You may need to release some of the relationships in order to get add and delete to work. But then things may not work as you intended.

That's all I can do for you guys.

Good luck and goodnight.

[help_me]

thanks for the help, not much further forward but well let you know when were on the dole

[David.Poundall]

Perhaps you need to think about a change in career direction.

On the face of it it may look like you are close to a solution but the two parts don't hang together. your best bet is to find the guy that did the database and get him to change the table structure around to match your code.

The database being the more complex of the two codes.

[help_me]

oh no, i just enjoy making sites

[help_me]

what should we get rid of? ?!?

[nemaroller]

I took a look at your db model, and it was definitely far too much...

With the diagram pic I have attached, you have the db structure you need to accomplish the assignment.

I'm looking into to some other parts of the db, mainly the forms, im not sure why there are some in the access db itself (perhaps the guy was just testing it)

[help_me]

what now?