Databases and standard practices 2

[Mezzzo]

Hi

I have a set of dbedit controls that the user enters the prices of parts based
on a certain class of part. There are three unique part types. I`d like to
save this to a dbtreeview by devexpresss. I`m not certain how to proceed.
Should I save the data direct to the tree or should I send the data to the
database and then to the tree. The treeview is used in this application to
list and allow the user to select a certain master node then click a buttom
to make this set of data active for subsequent calculations.
PS, I`m just starting to learn databases as you probably guessed. I apologize
in advance if this is a stupid question.
Chev
- Door Handle
Door Lock
Door Key
Ford
- Door Handle
Door Lock
Door Key

 

[richardchaven]

If the data is to go into a database eventually, then put it in early. That way, you can fill the TreeView from previously entered data using the same routine.

I do not know anything about dbtreeview by devexpresss (although their controls are highly recommended by many), so I cannot help you write that routine.

Cheers

 

[delphiman]

It seems to me you need a Master/Detail relationship between two tables. Whereby (in the Master Table) you can have Chev,Ford,Holden, etc. and (in the Detail Record) you have Door Handle, etc. etc.

Or perhaps the other way around. With Door Handle, etc. etc. being records in the Master Table and Ford, etc in the Detail Table.

If you'd like a working model to work from contact me in seperate e-mail at delphiman@bigpond.com