Searching Records

[statistics]

I have a parent table called patient info. and a child table called fills. The database in the future will become very large, and will be difficult to find a particular patient in the parent table to update fills in the child table. How can I search through the parent table with ease so that I can update fills?
Thanks for those who help!

 

[sfreeman@co.mer]

The size of the db will not greatly impact your ability to locate a particular record. There are many, many ways to locate records, so more info is needed to give meaningful advice.

Look in the Help file for parameter queries, filters, and such to get started.

You can also use VBA. Look up Find and Seek methods.

Make sure you have a proper table relationship set up between patients and fills.

HTH