19/5 Starting slowly on Interface

_________________________________________________________
Start 9.00 a.m.
_________________________________________________________
I was just having an issue with the management business name not updating because of "The UPDATE statement conflicted with the REFERENCE constraint". What i forgot to do was set the cascade update and delete. Will do that now.

Management(businessName) --> cascade update --> ManagementAddress(businessName)
client(clientID) --> cascade update & delete --> clientAddress(clientID)
user(userID) --> cascade update --> job(clientID)

Because management is only inserted once, then updated, each time this is updated it needs to update the business name in the addresses also. If the client id is changed (i dont see why this would happen) then the addresses of that client will also need to be updated, as well as, if the client is deleted, all of the addresses will likewise be deleted. If the odd case of the user assigned to a job is changed, i have made it so that this will also cascade update.

So i fixed all of my problems (i'll update problem page) besides this stupid passing of lists. I made a class to convert the list into a multi dimensional array to pass back... stoopid me, cant even pass those lol. After reading this article and a few others http://www.west-wind.com/WebLog/posts/368.aspx i realised that people seem to be just passting datasets... I am going to wait until another time to get advice about this and move onto the interface stufffff.

************************************************************************
Break 4.00 p.m. - 5.00 p.m. gone for walk
************************************************************************

Ive worked a little more on the list/array issue, will talk more about that tonight or tomorow when i figure out if its gonna work. The rest of the day i spent making the master form, the sitemap, and implementing the website security. I made the forms for adding clients, users, client addresses, management addresses and jobs. Tomorow i will carry on with passing the lists and filling the grid views with this data, hopefully if i dont have any problems i will also get deleting and editing done. I have class tommorow night though, so have to catch up on some project management, ah well, will see how it goes. Raiding time!

_________________________________________________________
Finish 9.00 p.m. 11 hours
_________________________________________________________