Hahahah you know whats funny about that is that this stuff is real life examples.
I mean you need certain tools to make certain things, etc.
But I know what you mean! It does help when you have other specific examples.

Actually I had knowledge of that Access one way before, but I was just so burnt out and confused nothing was making sense to me anymore hahah. All I do is learn how I can make my game, since I don't have a job; so sometimes my brain burns out from reading so much. Thank you SOOOOO much for your time...

Thanks a lot (: I think I figured it out. As you can see, I split things up into smaller tables, and actually ended up putting a couple into one table. Then I linked them appropriately. If you're wondering what this is for (to see the reasoning behind these tables), it's a text based browser game (;...

Thank you Jack! I was pretty confused for a minute there, but you cleared that right up! I'm still pretty frustrated with figuring out this junction table. It was easy at first but now there's relationships everywhere and I'm getting overwhelmed. Lol. But I'll get it. Probably just start with a few ...

Right~! That's what I attempted to do in my other follow up post example. The one thats colorful. Did I sort of do it right? Sorry I know I'm such a newbie, but I really do appreciate the help guys. <3 Also, I thought foreign keys were what linked the tables, and created those relationships? If I do...

So if I had example tables, that go with the way the game is supposed to run, would it look sort of like this? Required Tool Table key required_tool_Fkey, //there will never be more than one of the same type of tool needed production_item_Fkey Required Resource Table key required_resource_id require...

EDIT : For anyone else needing help with this craziness, it really helped to look at this website: http://office.microsoft.com/en-us/access-help/database-design-basics-HA001224247.aspx I know it's for Access, but that doesnt matter. What matters is the clear definition and examples of many to many ...

Thanks for the warm welcome!

Heyyyy everybody. I've been perusing this site for a little bit, and I thought I'd join up; being an up and coming programmer and all.

(:

Thanks for all the awesome tutorials/resources on here by the way. It's really nice to see, especially since I'm a self-learner.