Huge Database

[a.mlw.walker]

Hi,
I have a huge databse with a form, showing record info. If I use a search button to search the databse it takes ages to find the record.
The quickest way is to find the record by hand, find the record number, copy that, and paste it into the form and hit enter.

Does anyone have any ideas how i can speed thing change over up.

Thanks
Alex

 

[Capo]

How are the tables setup? Do those tables have a primary key assigned to them?

 

[neileg]

In gerneral, indexing the field that you are searching on should speed up the process.

 

[a.mlw.walker]

huge database

Thanks for replies. How do i go about adding primary keys or indexing fields.

Thanks
Alex