Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
InNomina
Starting Member
40 Posts |
 Posted - 2012-02-01 : 11:09:37
|
| I have 3 tables in a work group.I click on the first table and select a record. I click on a link and it takes me to the items associated with that record.I am now viewing both record and items.I click on the next link and it takes me to the pages in the items with in that record.3 tiers of workflowI print a label at the 3rd tier. My problem is I need info from the first tier on the label.Tables:Clients.....folders......recordsClients table as a column called Abrev that I need at the records level < a look up will not due>thoughts? |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2012-02-01 : 11:18:52
|
| What is the issue you are having? Can't you just join the three tables together and filter by the current Records primary key?http://www.sqlservercentral.com/articles/Best+Practices/61537/http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
 |
|
|
InNomina
Starting Member
40 Posts |
Posted - 2012-02-01 : 11:40:33
|
| I see what im doing wrong now, I had not added my look up columns to the 2nd tier.Thanks for the comments!-------------------------"If you never fail, you're not trying hard enough" |
|
|
|
|
|
|
Inner Join