[2005] Relationship Desing Help

Hello guys,

I've been trying to organize my data to make my life easier during the project and i was wondering if you guys could give me tips.

Basically so far i have:
()being folder

Code:

---

(client)
Client1.txt
Client2.txt
........

       

Code:

       

---

The client .tx files looks as follows
Client1:
Date                    Value
31.12.2001             100
01.01.2002             101
...

---

---

[CODE](cd_client)
cd_client.txt

Code:

---

The cd_client looks as follows
Name              ref_currency          Tax    %
client1                  USD                  Yes    30
client2                  EUR                  No      40
...

---

[CODE]

Code:

---

(Products)
Prod1(USD).txt           
Prod2(EUR).txt
...

       

Code:

       

---

The prod1(USD) table looks as follows
Date                     Value
31.12.2001             100
01.01.2002             110
...

---

---

Code:

---

(Currency)
CHFUSD.txt
CHFGBP.txt
...

       

Code:

       

---

hte CHFUSD table looks as follows:
Date                     Value         Inverse
31.12.2001             0.63            1.57 
01.01.2002             0.64            1.58
...

---

---

Code:

---

(Position)
client1.txt
client2.txt
...

       

Code:

       

---

this table is a form that the value is inserted manually and the result is always the sum of the values between the period

---

---

And basically what i want to do with this database:
Get the quartely average of the tables of (client) folder
Get the montly average of the tables of (prod) folder
Use the (cd_client) file to set the prod avg in the reference currency of the cliets. By that i'll have to use the currency tables.

Any help will be appretiated since im not very good on this

thx in advance

You're storing your data in text files? Is there a reason you're not using a database?

actually the txt files are exported from the database we are running now. But i dont have access to the sql database. That is why i dicided to create one in access from the.txt files that are being exported