firstly I am not a coder so apologies if my question seems really low tech.
I have created a database, a dynamic page and a normal page to list the items in the database and link each one to the dynamic page. All works well.
https://andy-blair.wixsite.com/xref-database/search - ignore the rest of the site, I am just testing the theory at the moment.
What I now want to do is add a search box as the list will be about 1000 items long when fully populated.
Basically instead of seeing the list I want users to be able to input a competitor's part number in a search box that will then display my part number which is linked to the dynamic page.
Any help gratefully received