This topic is locked

help with Searching Records from Link

5/23/2003 8:03:57 AM
ASPRunnerPro General questions
author

Hi, I am just a beginner at this and wonder if someone could help me please. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=75&image=1&table=forumtopics' class='bbc_emoticon' alt=':unsure:' />
I have created two screens, one showing customers and the other showing orders. I would like to display a link next to each customer name that would take me to a search results screen that displayed just the orders from that person, much as I would get if I used the search facility at the top of the screen; e.g. My Customer ID > Equals > Customer number 2 (looking at the Orders table).
I've read on this board that I can enter a URL in the customer table and have that appear on the screen as a link (even with a button). What I would like to know is, if there is a way of creating a link that contains a search query, and if so what it would look like?
(I am also wondering if I should not be doing this as a query in Access, but this is friendlier software! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=75&image=2&table=forumtopics' class='bbc_emoticon' alt=':D' /> )
Laura

admin 5/23/2003

Laura,
you need to modify customers page to add a column with link to orders page

which also passes CustomerID.

On the orders page you need to read this CustomerID and read orders that belong to this customer only.
If you need help doing this just send me all your files to support AT xlinesoft.com and I'll make required changes.
Sergey Kornilov

500036 6/1/2003

This would be a great feature to be included in product. At least I need all the time this kind of solutions: user goes first to order list and likes to jump to order details from there and from order details to row details and back. This is great tool also without that feature, but with that it would be everything I could ever hope. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=236&image=1&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' />
Bill

admin 6/2/2003

Bill,
master-detail relationship support will be added in one of the following versions of ASPRunner.
Sergey Kornilov