search without primary key

[mrijet]

Hi...

I have created Inventory System by using Microsoft Access...
One of staff there requested to me too add function search...

Is there any possibilities for me to create search function without primary key ?

Any suggestion or advises regarding my problem?

[Seth Schrock]

You can search based on any field the same way that you search for a primary key value. Perhaps more information about what you are searching might help us help you.

[mrijet]

Thanks for replying this conversation Seth, really appreciate that man....


For now I create search function that has primary key for them to search...

Now they requested at me to create function search for that particular key...and it can list the details of information of that particular things for them...even though that particular key that they request me to create the search function are seldom they key in for the details information in the my system...

[Seth Schrock]

Again, you search for any field the same way that you search for a key value. You can either do it in a form filter or in a WHERE clause in a query.