[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
Re: [2005] Relationship Desing Help
You're storing your data in text files? Is there a reason you're not using a database?
Re: [2005] Relationship Desing Help
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