Hi Everyone,
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.
thanks for your reply and the link to the really useful article. However, it doesn’t help with my issue. I need to be able to search the list rather than just select from it.
Use a text box and a search button with an onClick event, where you can use a filter on the Dataset that is connected to the repeater, as explained in the article.
You can use a ‘contains’ filter if you want to search for any part of the string, or an ‘eq’ filter if you want an exact match.
Hi all, thanks Uri for your input it really helped me. However, I am now facing another roadblock. I have a list connected to a dynamic page and I can search this list so all is good there.
My problem now is this.
the list connected to my dynamic page is of my products and is about 50 lines with lots of details and an image of my product.
I want users to be able to enter a competitor’s part number and find mine. The list of competitor’s numbers is about 1000 lines long i.e a 20 to 1 relationship with my products.
I can visualise what I want to do and how it would work in Access etc but don’t seem to be able to link the two datasets on my site.
I want the data input to search the many to one table but display the result from the details table which is then linked to my dynamic page.
Any ideas?
Are you still working on this? I “MAY” have a solution for you… I’m STILL working on it as I write these lines, but I think it’ll be just perfect for you.
MY case is quite similar to yours. Instead of competitors’ part numbers, it’s outdated or equivalent part numbers that I’m working with.
Example part abcdefg may have been replaced by part abcdefh, which was replace by i and so on. Or equivalencies may have part numbers 1234567 and a1b2c3d4.
Therefore, I’m trying to find the CORRECT way to have a search box search in ALL of the database, since the results may be found in part_no, replaced_by, equivalency_1, equivalency_2, etc…
If anyone has answers, you’ll be making TWO people happy
If I find before anyone answers, I’ll keep you posted.
Hi,
yes I am still looking for a solution.
I now have a partial solution but it involves two datasets with two separate search boxes and two separate results tables.
Box 1 searches the many to one list to find my part number. you input a competitor number and it publishes my number in the results box.
Box 2 searches my index table (once you have found my part number). This is connected to a dynamic page with details of my product.
You can take a look here . Enter K003781 in the box on the left and it will produce my part number below. Then enter the result in the box on the right. Then you can click the result in the table below and it takes you to the (dynamic) details page
While this works it is a bit of a long winded process.
What I am now trying to achieve is to connect the two datasets so that I only have one search box and one results table. so that if you enter a competitor number in the search box (what is effectively box 1 now) it produces a result in what is results table 2 now.
In theory, according to the articles that I have read, I should be able to achieve this by filtering one dataset by another but so far I have failed.
Someone may correct me if I’m wrong, but I think that your solution here would be to have your search box search directly in your main database, which then refers to your databases containing your competitors numbers.
The way that I started doing it on my side :
Search box :
Visitor enters any part number : interchange, provider 1, 2, 3, etc…
Database 1 : Contains the MAIN part numbers and referred fields from the other databases
Main database field # 2 refers to Database 2 : contains the part numbers of provider 1, wich, in your case, would contain the part numbers of competitor 1.
Main database field # 3 refers to Database 3 : contains the part numbers of provider 2, wich, in your case, would contain the part numbers of competitor 2.
And so on…
Can you post here your code please? Right now I’m in a bit of a hurry, I don’t have time to post mine, but I’ll post it later.
Since you’re also in car parts… or at least in calipers, maybe we could even exchange some infos that we have
