Find using multiple fields.

[Rotorian]

Hello everyone,

This might be simple to yas, but has me stomped.

I need to find records related to an item number. However, this item number may have been entered in the database at several different dates, depending on when and how often my users have seen the item.

No problem so far. I made a find report layout where users can do a search by item number, and date. However, I want the field to use a value list of dates related only to that item number. Right now when I use "date" as the value list, all dates for all records are displayed.

For example, in "item number" field, the user enters 307, user tabs to "date" field which displays a value list since the database was created in 12/04. How can I make that value list display only dates related to 307? That way the user doesnt have to scroll thru dates since 12/04?

Make sense?

Thank you.

[Rotorian]

Okay gona be a little more specific.

I made a new field "datesearch" to auto enter a calculated valute where [datesearch = item AND date] then in layout I set datesearch field to include scroll bar. however, nothing gets return as an option to use in order to complete search. So, in find mode I enter item number is "item" field, tab over to "date" and a blank list pops up . However, I know there is multiple entries for item 307 with different dates.