Mark Brown's Blog

So, of course the main purpose of writing any web app as I see is is to be able to write, edit and retreive data from databases. So, not being much of a database expert, or really even that familiar with Relation databases. This has proven to be an interesting exercise in patience for me!

Here's the problem. Well, problem to me, probably baby food stuff for most of you. I've got a database with a couple of tables. One table is for accounts, the other is for notes. The notes are supposed to be attached to the account based on the accountid. Well, at least that the field I mapped it to in the MS Access. Thinking is, I've got one account, but multiple notes for each account, and I want to be able to view the account with all the notes attached to that account. Sounds easy enough, don't it. Yea, right.... LOL. Believe it or not it is fun trying to figure this stuff out. Any way. I have yet to figure out how to make the notes attach to the account.

Here's my thinking. When the account is created, you get a chance to enter the intial note for the account. I can get the account info saved in the account table, and I can get the notes to save in the notes table, but I haven't quite figured out how to link the two. I look in the notes table in the db and I see a blank area where the accountid should be even though I though I told it to input the account ID in the table in the code???

Of course I'm leaving a lot of pertinate information out here but I'm still working on this and as soon as I get if figured out I'll post the code and an explanation.

So, off to bed. I've got to be to work at 7am in the morning. I'll update this as soon as I get it done.

Later,

Mark