Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:00,450 --> 00:00:06,650
There are two types of table relationships in power be at desk top active and inactive.
2
00:00:06,690 --> 00:00:08,430
Consider a case like this.
3
00:00:08,550 --> 00:00:15,240
Our sales data contains to date fields an order date and a stock date and well you can connect both
4
00:00:15,240 --> 00:00:18,540
of them to the date field in the calendar lookup table.
5
00:00:18,540 --> 00:00:21,380
Only one can be active at a time.
6
00:00:21,420 --> 00:00:24,740
That's why one of these relationships shows up with a solid line.
7
00:00:24,870 --> 00:00:29,840
That's the active one and the other shows up at that dotted line which is the inactive one.
8
00:00:29,850 --> 00:00:35,280
Now if you edit both of these relationships you'll see that one has the checkbox where it says make
9
00:00:35,280 --> 00:00:37,080
this relationship active.
10
00:00:37,080 --> 00:00:38,680
The other does not.
11
00:00:38,790 --> 00:00:44,670
Now you can toggle these back and forth but the one catch is that you have to deactivate the active
12
00:00:44,670 --> 00:00:48,000
one first before you activate the other.
13
00:00:48,000 --> 00:00:53,470
In other words there can be no point in time where both of those checkboxes are activated.
14
00:00:53,880 --> 00:00:58,040
So let me show you what this looks like in the relationships view.
15
00:00:58,210 --> 00:01:04,000
OK so here we are back in our Adventure Works model as you can see we've got these two date fields in
16
00:01:04,000 --> 00:01:06,910
our sales table order date and stock date.
17
00:01:06,940 --> 00:01:11,950
Right now we're connected to the calendar table based on order date which in this case is our primary
18
00:01:11,950 --> 00:01:12,890
date field.
19
00:01:13,240 --> 00:01:19,570
But what we can do is grab stock date as well without deleting our order date relationship and drag
20
00:01:19,570 --> 00:01:22,550
it up to date so that both are connected.
21
00:01:23,470 --> 00:01:29,950
Now you see that it added another relationship one of which is dotted which is the second one we added
22
00:01:30,070 --> 00:01:31,260
stock.
23
00:01:31,450 --> 00:01:33,350
The other is solid order date.
24
00:01:33,370 --> 00:01:35,070
That's the active relationship.
25
00:01:35,290 --> 00:01:42,940
And remember if I double click the inactive stock date relationship and try to activate it it won't
26
00:01:42,940 --> 00:01:48,600
let me because it says there's already an active relationship between sales and the calendar Look-Up.
27
00:01:48,610 --> 00:01:54,130
So I've got to deactivate or delete that existing relationship before I can activate this one.
28
00:01:54,130 --> 00:01:57,480
So I need to uncheck press OK.
29
00:01:57,550 --> 00:02:06,480
Basically the process looks like this start with order date de-select to make that one inactive I've
30
00:02:06,480 --> 00:02:10,200
got two inactive relationships here.
31
00:02:10,580 --> 00:02:17,240
And then I can double click and activate my relationship between the stock date and the calendar date.
32
00:02:17,480 --> 00:02:18,360
So there you go.
33
00:02:18,410 --> 00:02:19,780
Just swap the two.
34
00:02:19,930 --> 00:02:26,900
And because order date is my true primary date field I'm going to go ahead and just reverse what I did.
35
00:02:26,900 --> 00:02:34,230
I want this stock date field to be available but not active and my order date is the one that I really
36
00:02:34,230 --> 00:02:34,960
care about.
37
00:02:35,730 --> 00:02:37,100
So there we go.
38
00:02:37,110 --> 00:02:42,150
So again I have both these relationships in place when I do need them.
39
00:02:42,170 --> 00:02:44,160
It can only keep one active at a time.
3903
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.