[2005] Relationship Desing Help

[super_nOOb]

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

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

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

[CODE](cd_client)
cd_client.txt

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

[CODE]

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

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

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

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

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

	
	
 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

[MarkDorf]

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

[super_nOOb]

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