No announcements
Found 789281 threads
-
0 VotesTable Relationship
I just try to avoid having two many-to-many relationships, the first between Item and Categories, and the second between Item and Subcategory and having to create junction ...Answered | 10 Replies | 4454 Views | Created by Corbex - Saturday, September 22, 2012 6:14 AM | Last reply by BIWORK - Tuesday, September 25, 2012 7:28 AM
-
0 Votes
table relationship in VB express
Here are tables i want to relate: Table 1: ArtistID ArtistName: Table ...Answered | 2 Replies | 7171 Views | Created by dbldown768 - Tuesday, December 19, 2006 2:32 PM | Last reply by Jayakumaur (JK) - Tuesday, February 18, 2014 7:42 AM -
2 Votes
Table relationship Purpose
http://social.msdn.microsoft.com/Forums/en-US/1f6f090f-df42-4d70-b24b-3fd84d5c3893/consequences-of-not-creating-relationships-between-tables?Answered | 4 Replies | 1414 Views | Created by Mehran52 - Monday, April 14, 2014 11:26 AM | Last reply by Kalman Toth - Monday, April 14, 2014 2:11 PM -
1 Votes
DSV table relationships
Hi There is no facility in the DSV to create exotic relationships.Answered | 1 Replies | 5103 Views | Created by sasman - Wednesday, May 27, 2009 6:51 AM | Last reply by John Shiangoli - Wednesday, May 27, 2009 8:08 AM -
1 Votes
Date Table Relationships
Its a limitation of powerpivot and you can have only one active relationship at a time The solution is to use USERELATIONSHIP function to activate ...Answered | 2 Replies | 965 Views | Created by Nikki-R - Monday, August 18, 2014 8:57 AM | Last reply by Michael Amadi - Monday, August 18, 2014 12:59 PM -
2 Votes
System Table Relationships
Taking this a step further: I am using the tables with Tableau, but I need relationship information from various tables.Answered | 3 Replies | 930 Views | Created by TWeil888 - Wednesday, January 20, 2016 3:52 PM | Last reply by Naomi N - Wednesday, January 20, 2016 8:30 PM -
3 Votes
Relationship between tables
Heavily modified OLTP tables - referential integrity check requires additional IO operations as well as an indexes in both tables.Answered | 7 Replies | 5430 Views | Created by ba7ranya - Tuesday, August 3, 2010 5:38 PM | Last reply by ba7ranya - Thursday, August 5, 2010 8:45 AM -
0 Votes
Relationships between tables
I've created relationship between these two tables: 1Dates can have many Tasks.Answered | 3 Replies | 3574 Views | Created by artxach - Tuesday, September 6, 2011 9:49 AM | Last reply by Jacob Wagner - Tuesday, September 6, 2011 5:14 PM -
0 Votes
Table relationships
Aniyaudi, You would wrap your both tables in a dataset.Answered | 5 Replies | 2529 Views | Created by aniyahudi - Friday, December 31, 2010 8:00 PM | Last reply by BonnieB - Monday, January 3, 2011 1:38 AM -
0 Votes
Tables relationship question
It seems like you are trying to violate referential integrity constraints, your table design should look like as below.Answered | 2 Replies | 828 Views | Created by Y a h y a - Monday, January 12, 2015 2:16 PM | Last reply by Chongtham Rajen Singh - Monday, January 12, 2015 2:48 PM -
1 Votes
Difficulty with Table Relationships
From your description you have three principle referenced entity types, Employees, Courses and Sets, which would be modelled by tables like ...Answered | 2 Replies | 665 Views | Created by wingrider54 - Friday, May 3, 2013 4:05 PM | Last reply by wingrider54 - Tuesday, May 21, 2013 12:50 PM -
0 Votes
Table Relationships in SQL DB
My LineID is the PK for this table.Answered | 3 Replies | 833 Views | Created by MeToo_ - Thursday, March 15, 2018 1:03 PM | Last reply by Ed Price - MSFT - Wednesday, April 11, 2018 12:28 AM -
1 Votes
4 tables with confusing relationships
Your current table will support duplicates.Answered | 6 Replies | 3465 Views | Created by gardner358 - Thursday, October 4, 2012 10:32 AM | Last reply by gardner358 - Thursday, October 11, 2012 11:25 AM -
2 Votes
Having Relationship with tables in dataset?
Yes, you can have relationship between tables in DataSet.Answered | 3 Replies | 1478 Views | Created by parote hitachi - Friday, September 9, 2011 12:58 PM | Last reply by parote hitachi - Friday, September 9, 2011 1:06 PM -
3 Votes
How do relationshiped tables behave
The scan_LogEntry table hold the foreign keys for the other tables.Answered | 3 Replies | 938 Views | Created by SolidNev - Wednesday, August 27, 2014 3:12 PM | Last reply by SolidNev - Thursday, August 28, 2014 7:19 AM -
1 Votes
PowerPivot Relationships not working in pivot tables
When there's a single table, then there are no relationships to navigate.Answered | 7 Replies | 11787 Views | Created by Gerrard.Hickson - Monday, November 17, 2014 11:46 PM | Last reply by greggyb - Wednesday, November 19, 2014 3:10 PM -
0 Votes
Creating relationships between tables
Hi newoay, I try to reproduce your scenario, please create a relationship between the table.Answered | 4 Replies | 883 Views | Created by newoay - Tuesday, April 11, 2017 10:04 AM | Last reply by Angelia Zhang - Wednesday, April 19, 2017 9:07 AM -
0 Votes
Relationships between Tables may be needed
Have you seen this blog post: http://www.powerpivotpro.com/2013/05/relationship-may-be-needed-but-i-already-have-a-relationship-whats-going-on/ I think it ...Answered | 1 Replies | 2250 Views | Created by Ashish Mathur - Friday, March 21, 2014 4:07 AM | Last reply by Darren Gosbell - Tuesday, March 25, 2014 6:37 AM -
0 Votes
Consequences of not creating relationships between tables?
Hi The purpose of creating relationship between tables is just data integrity(consistency and validity)?Answered | 6 Replies | 8269 Views | Created by ptflyer - Friday, April 22, 2011 11:09 AM | Last reply by Kalman Toth - Monday, April 14, 2014 1:59 PM -
1 Votes
Dimension usage relationships with referenced tables
First Yes you will if you want the table to be a Dimension as a reference dimension in the Cube outside of the Main Table as a dimension.Answered | 1 Replies | 559 Views | Created by AngelosPs - Wednesday, May 11, 2016 2:23 PM | Last reply by Thomas L. LeBlanc (MVP) - Wednesday, May 11, 2016 4:18 PM - Items 1 to 20 of 789281 Next ›
No announcements
