I want to use UD4 and access 2000 to build a forum like this one, but I realized that I have no skill at designing databases. I also have no clue how to join databases. I can do simple databases and I'm fairly familier with Access but I have no Idea were to start. I tried replicating the snitz database but was unable to understand how they built it. So far it's been trial and error(I mean error every time!). So My question to you all is there anything out there online to show me the right way to build databases from a beginners point of view?

If you know of any tutorials etc. let me know.

Thanks in advance,
fliquid

This one looks good for your configuration>>>>

www.webthang.co.uk/tutorials/gor_forum/p1.htm
try this one
or if you want a c# source code

www.csharpfriends.com/Members/Main/Source/

www.blueworld.com/blueworld/articles/

can also check out some asp sites

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>

This one looks good for your configuration&gt;&gt;&gt;&gt;

www.webthang.co.uk/tutorials/gor_forum/p1.htm
try this one
or if you want a c# source code

www.csharpfriends.com/Members/Main/Source/

www.blueworld.com/blueworld/articles/

can also check out some asp sites
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Thanks for the reply. I've allready gone through that ultraeasy tutorial but still have no clue how the SQL they used to join tables actualy works. I don't use C# at all just Vbscript no .net

Basicaly I would just like to know how to join certain tables like so:

ForumCategories(Table)
- CatID v

Forums
- CatID ^
- ForumID

Just making it so that the Forums table gets its CatID from the ForumCategories Table.



Thanks,

fliquid

Edited by - fliquid on 21 Jun 2002 16:44:04

Edited by - fliquid on 21 Jun 2002 16:44:39

Your never gonna get anywhwere by jumping in too deep and losing yourself with statements you don't understand.
Start off with small things, (login pages, a little mailing list, learning how to use URL variables etc..)
If you do it the right way first time, not only will it save you a lot of headaches, you will take a lot more info in and learn quite quick.
I myself only started using the ASP/VBScript around 3 months ago, and upto now, ive built search engines, a portal site, and other little gizmo's which i'm still looking at and improving as i learn more.

Morale of this answer is: "Don't bite off more than you can chew"

"Nobody ever said this stuff was easy"

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Start off with small things, (login pages, a little mailing list, learning how to use URL variables etc..)
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

I've done all of these and more and I understand how the ASP code works, Maybe I didn't explain myself too well.
What I realy need help with is knowing how to join databases properly either by straight SQL or through Access. I agree with you completly about starting with easy stuff. I asumed joining two tables should be an easy task.

Thanks,

Fliquid