Board index » delphi » A Database problem

A Database problem

Hi!

I am newer than a newbie in programming and hoop somebody can help my with
my little problem.

I had created a Database (named Main-list) in my application with a column
named Short-name and a Database (named Price-info)  My problem is that
everytime I add a new Short-name in "Main-list" I want my program to make a
copy of "Price-info" and rename it to the Short-name in the Short-name
column. The big issue is I have a Database(Main-list) with all the personal
info and a smaller database(Price-info) for every Short-name in
"Main-list". I am go-ing to use the info in "Price-info" to Draw some
graph's.

1)      Is it good practice to do it this way?
2)      Where can I find some samples to work with?

Thank for the good work that everybody do when answer the questions, some
of my other questions are already being answered.

Gert
g...@{*word*104}serv.co.za

 

Re:A Database problem


Gert,
Please clarify whether you are working with two tables or two databases. Also,
I am confused by your reference to columns etc. Sned some more details nad
perhaps I can help.

Quote
Gert Duvenage wrote:
> Hi!

> I am newer than a newbie in programming and hoop somebody can help my with
> my little problem.

> I had created a Database (named Main-list) in my application with a column
> named Short-name and a Database (named Price-info)  My problem is that
> everytime I add a new Short-name in "Main-list" I want my program to make a
> copy of "Price-info" and rename it to the Short-name in the Short-name
> column. The big issue is I have a Database(Main-list) with all the personal
> info and a smaller database(Price-info) for every Short-name in
> "Main-list". I am go-ing to use the info in "Price-info" to Draw some
> graph's.

> 1)      Is it good practice to do it this way?
> 2)      Where can I find some samples to work with?

> Thank for the good work that everybody do when answer the questions, some
> of my other questions are already being answered.

> Gert
> g...@{*word*104}serv.co.za

Other Threads