forum.vdsworld.com

[DelWolf]

Hello,

I am trying to make a database using vds.
Currently I have constructed a program that can access different txt files for information.

What I want to do is make all the information run from one database, that would be easy to search, add and delete data, etc.

The information i need is like this.

Manufacturer
Model
Ink
ID


The first field manufacturer is simple text, normally containing something like epson or canon, etc. Same with the model, it only contains simple data such as i250, sytlus rx200, etc.
But the third field has two sections. Compatible and Original. Within these sections, their can be more then 10 products. ID, is just a code field.

I want to make it so i can search for a model, manufacturer, ink, id, etc.
The search i have made right now can search but only ever displays one result if i type something such as hp.

How can I make it so then when i search all result that match display?
I am keeping the search types on to their own controls.

How do i build a database that can work in one file, and be fully searchable?

I know this must sound mad, i this even possible???

Thank you

[Vic D'Elfant]

Hmm I would suggest to use a MS Access database to store the info, and use the vdsdll3 "vdsdb.dll" component to handle the database communication

Vic