Dynamic Hyperlinks

Results 1 to 2 of 2

Thread: Dynamic Hyperlinks

  1. #1
    Join Date
    Dec 1969

    Default Dynamic Hyperlinks

    I have two Access tables: Part and SalesOrder<BR>Both tables share a common field PartNumb (this is not a primary key field). How do i retrieve information from SalesOrder table using the PartNumb field as a hyperlink from the Part table

  2. #2
    Join Date
    Dec 1969

    Default RE: Dynamic Hyperlinks

    Hi,<BR><BR>You could try this. Basically you&#039;re selecting "SalesOrder" where "Part" is equal to "Part".<BR><BR>&#060;td&#062;&#060;a href="SomePage.asp?Part=&#060;%=Part%&#062;"&#062; &#060;%=SalesOrder%&#062;&#060;/td&#062;<BR><BR>The only problem is that "Part" is not unique. So what will happen is that you will be returned the first record that is found. This may not be the record you&#039;re expecting.<BR><BR>Derry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts