Forums: help with Searching Records from Link - Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • This topic is locked

help with Searching Records from Link Rate Topic: -----

#1 User is offline   Laura 

  • Newbie
  • Pip
  • Group: Members
  • Posts: 1
  • Joined: 23-May 03

Posted 23 May 2003 - 12:03 PM

Hi, I am just a beginner at this and wonder if someone could help me please. :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! :D )

Laura
0

#2 User is offline   admin 

  • Administrator
  • PipPipPip
  • Group: Admin
  • Posts: 15471
  • Joined: 03-February 03

Posted 23 May 2003 - 07:31 PM

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
Best regards,
Sergey Kornilov
0

#3 Guest_Bill_*

  • Group: Guests

Posted 01 June 2003 - 02:43 PM

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. :rolleyes:

Bill
0

#4 User is offline   admin 

  • Administrator
  • PipPipPip
  • Group: Admin
  • Posts: 15471
  • Joined: 03-February 03

Posted 03 June 2003 - 03:21 AM

Bill,

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


Sergey Kornilov
Best regards,
Sergey Kornilov
0

Page 1 of 1
  • You cannot start a new topic
  • This topic is locked