Not sure, need help

Results 1 to 2 of 2

Thread: Not sure, need help

  1. #1
    Join Date
    Dec 1969

    Default Not sure, need help

    I have a table that has a great deal of information stored in it. To cut down on the time it takes to run through the fields I&#039;ve created seperate tables for all the info that could be used in a dropdown on the web. So I replaced all the fields on the main table with IDs to reference the Dropdown Tables. So instead of having the text strings in the main table it has a number that references it&#039;s own table that stores the text string. My question is this:<BR><BR>1<BR>How do I go about having my main table take it&#039;s value for the reference field and have it display the actual value from the other table.<BR><BR>2<BR>I have a page that lists the contents of the main table but the values appear as the reference IDs, how do I get the text string from the other table?<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default Research JOINs.

    If you have MS Access installed, it&#039;s a great reference for the SQL language.<BR><BR>If you have SQL Server installed, refer to the Books Online.<BR><BR>-Doug

Posting Permissions

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