help with Searching Records from Link
Posted 23 May 2003 - 12:03 PM
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! )
Posted 23 May 2003 - 07:31 PM
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.
Posted 01 June 2003 - 02:43 PM