help with Searching Records from Link
Rate Topic:

Hi, I am just a beginner at this and wonder if someone could help me please.

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! )

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.

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.