Results 1 to 3 of 3

Thread: [RESOLVED] Column that counts occurrences of FK in another table

Threaded View

  1. Aug 21st, 2013, 10:12 AM #3
    wolf99
    wolf99 is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Apr 2007
    Location
    cobwebbed to PC
    Posts
    311

    Re: Column that counts occurrences of FK in another table

    OK, thanks.

    The reason i was asking is that I have some code that runs a query on the Program table to get the ID and ProgramName. With the setup as you suggest (and what I currently have) another query is needed, of the ProgramStep table to get the number of steps.

    I thought if there was a column with this info already in a column in the Program table it would negate the need for a second query...
    Last edited by wolf99; Aug 21st, 2013 at 10:22 AM.
    Thanks
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width