Creating a database

[Skyeam]

Hello,

 

I'm planning to make a database with ms access 2007. It'll be about Runescape prices in the GE. I want to display the price from an item at a certain date. Of course I will be having multiple items. However, I can't find out how I should create my database.

 

 

 

I started with 3 tables. The First one was just Item info, containing the columns: Item_ID (=jagex item id) ; Item_name ; Item_P2P (=F2P or P2P) ; Item_HighAlchVal ; ...

 

The second was just about the date: Date_ID

 

The third talked about the price: Price_ID ; Date ; Item_ID ; Price

 

 

 

The first table was linked to the third by Item_ID to Item_Id. The second to the third by Date_ID to DAte_ID.

 

 

 

However, I get a huge table then with not much structure: different dates and times mixed. But I can't find a way to structure it without having to create a new table for every Item... Which Is way too much work...

[sloter]

Are you planning on running this on the web?

[Skyeam]

Are you planning on running this on the web?

 

 

 

Currently I'm just working offline on the access. The prices will be automatically integrated from the runescape website.

 

 

 

Maybe Later I will synchronize it with an online mySQL server, but first things first.

[ClareJonsson]

It's probably because of the join type between your tables, access by default performs an inner join which returns ALL data connected between tables, you probably need to do an outer join between your tables.

 

 

 

For more info on this take a look HERE.

 

 

 

Alternatively, if you can upload your DB I can take a look and amend if you like?