By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,730 Members | 1,546 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,730 IT Pros & Developers. It's quick & easy.

search without primary key

P: 64
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?
Jun 9 '15 #1
Share this Question
Share on Google+
3 Replies


Seth Schrock
Expert 2.5K+
P: 2,951
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.
Jun 9 '15 #2

P: 64
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...
Jun 11 '15 #3

Seth Schrock
Expert 2.5K+
P: 2,951
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.
Jun 11 '15 #4

Post your reply

Sign in to post your reply or Sign up for a free account.