/ PCMania 8 / PCM8.iso / filemaker / data1.cab / FileMaker_Pro / FMRsrc.dll / STR_ / 1008

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 22 25 30 22 20 63 61 6e | 6e 6f 74 20 62 65 20 64 |"%0" can|not be d|
|00000010| 65 6c 65 74 65 64 20 62 | 65 63 61 75 73 65 20 69 |eleted b|ecause i|
|00000020| 74 20 69 73 20 75 73 65 | 64 20 62 79 20 74 68 65 |t is use|d by the|
|00000030| 20 66 69 65 6c 64 20 22 | 25 31 22 2e 00 22 25 30 | field "|%1".."%0|
|00000040| 22 20 63 61 6e 6e 6f 74 | 20 62 65 20 64 65 6c 65 |" cannot| be dele|
|00000050| 74 65 64 20 62 65 63 61 | 75 73 65 20 69 74 20 69 |ted beca|use it i|
|00000060| 73 20 75 73 65 64 20 69 | 6e 20 74 68 65 20 73 63 |s used i|n the sc|
|00000070| 72 69 70 74 20 22 25 31 | 22 2e 00 22 25 30 22 20 |ript "%1|".."%0" |
|00000080| 63 61 6e 6e 6f 74 20 62 | 65 20 64 65 6c 65 74 65 |cannot b|e delete|
|00000090| 64 20 62 65 63 61 75 73 | 65 20 69 74 20 69 73 20 |d becaus|e it is |
|000000a0| 75 73 65 64 20 62 79 20 | 74 68 65 20 22 25 31 22 |used by |the "%1"|
|000000b0| 20 72 65 6c 61 74 69 6f | 6e 73 68 69 70 2e 00 46 | relatio|nship..F|
|000000c0| 69 65 6c 64 20 6e 61 6d | 65 73 20 6d 75 73 74 20 |ield nam|es must |
|000000d0| 62 65 20 62 65 74 77 65 | 65 6e 20 31 20 61 6e 64 |be betwe|en 1 and|
|000000e0| 20 36 30 20 63 68 61 72 | 61 63 74 65 72 73 2e 20 | 60 char|acters. |
|000000f0| 20 50 6c 65 61 73 65 20 | 74 79 70 65 20 61 20 76 | Please |type a v|
|00000100| 61 6c 69 64 20 66 69 65 | 6c 64 20 6e 61 6d 65 20 |alid fie|ld name |
|00000110| 62 65 66 6f 72 65 20 63 | 6c 69 63 6b 69 6e 67 20 |before c|licking |
|00000120| 74 68 65 20 63 72 65 61 | 74 65 20 62 75 74 74 6f |the crea|te butto|
|00000130| 6e 2e 00 54 68 65 20 66 | 69 65 6c 64 20 6e 61 6d |n..The f|ield nam|
|00000140| 65 20 22 25 31 22 20 69 | 73 20 6e 6f 74 20 75 6e |e "%1" i|s not un|
|00000150| 69 71 75 65 2e 00 54 68 | 69 73 20 6c 6f 6f 6b 75 |ique..Th|is looku|
|00000160| 70 20 75 73 65 73 20 74 | 68 65 20 66 69 65 6c 64 |p uses t|he field|
|00000170| 20 22 25 30 22 20 69 6e | 20 69 74 73 20 64 65 66 | "%0" in| its def|
|00000180| 69 6e 69 74 69 6f 6e 2e | 20 43 68 6f 6f 73 65 20 |inition.| Choose |
|00000190| 61 6e 6f 74 68 65 72 20 | 66 69 65 6c 64 2e 00 54 |another |field..T|
|000001a0| 68 65 20 63 61 6c 63 75 | 6c 61 74 69 6f 6e 20 72 |he calcu|lation r|
|000001b0| 65 73 75 6c 74 20 74 79 | 70 65 20 6f 66 20 22 25 |esult ty|pe of "%|
|000001c0| 30 22 20 63 61 6e 6e 6f | 74 20 62 65 20 63 68 61 |0" canno|t be cha|
|000001d0| 6e 67 65 64 20 62 65 63 | 61 75 73 65 20 22 25 30 |nged bec|ause "%0|
|000001e0| 22 20 69 73 20 75 73 65 | 64 20 62 79 20 22 25 31 |" is use|d by "%1|
|000001f0| 22 2e 00 54 68 65 20 66 | 69 65 6c 64 20 74 79 70 |"..The f|ield typ|
|00000200| 65 20 6f 66 20 22 25 30 | 22 20 63 61 6e 6e 6f 74 |e of "%0|" cannot|
|00000210| 20 62 65 20 63 68 61 6e | 67 65 64 20 62 65 63 61 | be chan|ged beca|
|00000220| 75 73 65 20 22 25 30 22 | 20 69 73 20 75 73 65 64 |use "%0"| is used|
|00000230| 20 62 79 20 22 25 31 22 | 2e 00 54 68 65 20 66 69 | by "%1"|..The fi|
|00000240| 65 6c 64 20 79 6f 75 20 | 73 65 6c 65 63 74 20 63 |eld you |select c|
|00000250| 61 6e 6e 6f 74 20 62 65 | 20 61 20 73 75 6d 6d 61 |annot be| a summa|
|00000260| 72 79 20 66 69 65 6c 64 | 2c 20 61 20 67 6c 6f 62 |ry field|, a glob|
|00000270| 61 6c 20 66 69 65 6c 64 | 2c 20 6f 72 20 61 6e 79 |al field|, or any|
|00000280| 20 66 69 65 6c 64 20 6f | 66 20 74 79 70 65 20 63 | field o|f type c|
|00000290| 6f 6e 74 61 69 6e 65 72 | 2e 00 54 68 69 73 20 66 |ontainer|..This f|
|000002a0| 6f 72 6d 75 6c 61 20 69 | 73 20 74 6f 6f 20 6c 6f |ormula i|s too lo|
|000002b0| 6e 67 20 74 6f 20 62 65 | 20 63 61 6c 63 75 6c 61 |ng to be| calcula|
|000002c0| 74 65 64 2e 20 20 42 72 | 65 61 6b 20 69 74 20 75 |ted.  Br|eak it u|
|000002d0| 70 20 69 6e 74 6f 20 74 | 77 6f 20 66 6f 72 6d 75 |p into t|wo formu|
|000002e0| 6c 61 73 2e 00 49 6e 20 | 41 56 45 52 41 47 45 2c |las..In |AVERAGE,|
|000002f0| 20 43 4f 55 4e 54 2c 20 | 45 58 54 45 4e 44 2c 20 | COUNT, |EXTEND, |
|00000300| 47 45 54 52 45 50 45 54 | 49 54 49 4f 4e 2c 20 4d |GETREPET|ITION, M|
|00000310| 41 58 2c 20 4d 49 4e 2c | 20 4e 50 56 2c 20 53 54 |AX, MIN,| NPV, ST|
|00000320| 44 45 56 2c 20 53 55 4d | 20 6f 72 20 47 45 54 53 |DEV, SUM| or GETS|
|00000330| 55 4d 4d 41 52 59 2c 20 | 61 6e 20 65 78 70 72 65 |UMMARY, |an expre|
|00000340| 73 73 69 6f 6e 20 77 61 | 73 20 66 6f 75 6e 64 20 |ssion wa|s found |
|00000350| 77 68 65 72 65 20 61 20 | 66 69 65 6c 64 20 61 6c |where a |field al|
|00000360| 6f 6e 65 20 69 73 20 6e | 65 65 64 65 64 2e 00 54 |one is n|eeded..T|
|00000370| 68 65 72 65 20 61 72 65 | 20 74 6f 6f 20 66 65 77 |here are| too few|
|00000380| 20 73 65 70 61 72 61 74 | 6f 72 73 20 69 6e 20 74 | separat|ors in t|
|00000390| 68 69 73 20 66 75 6e 63 | 74 69 6f 6e 2e 00 54 68 |his func|tion..Th|
|000003a0| 65 72 65 20 61 72 65 20 | 74 6f 6f 20 6d 61 6e 79 |ere are |too many|
|000003b0| 20 73 65 70 61 72 61 74 | 6f 72 73 20 69 6e 20 74 | separat|ors in t|
|000003c0| 68 69 73 20 66 75 6e 63 | 74 69 6f 6e 2e 00 54 68 |his func|tion..Th|
|000003d0| 65 72 65 20 61 72 65 20 | 6d 6f 72 65 20 22 29 22 |ere are |more ")"|
|000003e0| 20 74 68 61 6e 20 74 68 | 65 72 65 20 61 72 65 20 | than th|ere are |
|000003f0| 22 28 22 2e 00 54 68 65 | 72 65 20 61 72 65 20 6d |"("..The|re are m|
|00000400| 6f 72 65 20 22 28 22 20 | 74 68 61 6e 20 74 68 65 |ore "(" |than the|
|00000410| 72 65 20 61 72 65 20 22 | 29 22 2e 00 41 20 6e 75 |re are "|)"..A nu|
|00000420| 6d 62 65 72 2c 20 74 65 | 78 74 20 63 6f 6e 73 74 |mber, te|xt const|
|00000430| 61 6e 74 2c 20 66 69 65 | 6c 64 20 6e 61 6d 65 2c |ant, fie|ld name,|
|00000440| 20 6f 72 20 22 28 22 20 | 69 73 20 65 78 70 65 63 | or "(" |is expec|
|00000450| 74 65 64 20 68 65 72 65 | 2e 00 41 6e 20 6f 70 65 |ted here|..An ope|
|00000460| 72 61 74 6f 72 20 28 65 | 2e 67 2e 20 2b 2c 20 2d |rator (e|.g. +, -|
|00000470| 2c 20 2a 2c 20 2e 2e 2e | 29 20 69 73 20 65 78 70 |, *, ...|) is exp|
|00000480| 65 63 74 65 64 20 68 65 | 72 65 2e 00 45 69 74 68 |ected he|re..Eith|
|00000490| 65 72 20 61 6e 20 6f 70 | 65 72 61 74 6f 72 20 77 |er an op|erator w|
|000004a0| 61 73 20 6f 6d 69 74 74 | 65 64 2c 20 74 68 69 73 |as omitt|ed, this|
|000004b0| 20 66 75 6e 63 74 69 6f | 6e 20 63 61 6e 6e 6f 74 | functio|n cannot|
|000004c0| 20 62 65 20 66 6f 75 6e | 64 2c 20 6f 72 20 22 28 | be foun|d, or "(|
|000004d0| 22 20 77 61 73 20 6e 6f | 74 20 65 78 70 65 63 74 |" was no|t expect|
|000004e0| 65 64 20 68 65 72 65 2e | 00 54 68 69 73 20 6e 75 |ed here.|.This nu|
|000004f0| 6d 62 65 72 20 63 61 6e | 6e 6f 74 20 62 65 20 65 |mber can|not be e|
|00000500| 76 61 6c 75 61 74 65 64 | 2e 00 54 68 69 73 20 66 |valuated|..This f|
|00000510| 69 65 6c 64 20 63 61 6e | 6e 6f 74 20 62 65 20 66 |ield can|not be f|
|00000520| 6f 75 6e 64 2e 00 54 68 | 69 73 20 66 69 65 6c 64 |ound..Th|is field|
|00000530| 20 69 73 20 69 6e 76 61 | 6c 69 64 2e 00 54 68 69 | is inva|lid..Thi|
|00000540| 73 20 74 65 78 74 20 63 | 6f 6e 73 74 61 6e 74 20 |s text c|onstant |
|00000550| 64 6f 65 73 20 6e 6f 74 | 20 65 6e 64 20 77 69 74 |does not| end wit|
|00000560| 68 20 61 20 71 75 6f 74 | 61 74 69 6f 6e 20 6d 61 |h a quot|ation ma|
|00000570| 72 6b 20 28 22 29 20 6f | 72 20 69 73 20 6c 6f 6e |rk (") o|r is lon|
|00000580| 67 65 72 20 74 68 61 6e | 20 32 35 33 20 63 68 61 |ger than| 253 cha|
|00000590| 72 61 63 74 65 72 73 2e | 00 54 68 69 73 20 65 78 |racters.|.This ex|
|000005a0| 70 72 65 73 73 69 6f 6e | 20 69 73 20 74 6f 6f 20 |pression| is too |
|000005b0| 63 6f 6d 70 6c 69 63 61 | 74 65 64 2e 20 47 45 54 |complica|ted. GET|
|000005c0| 53 55 4d 4d 41 52 59 20 | 66 75 6e 63 74 69 6f 6e |SUMMARY |function|
|000005d0| 73 20 63 61 6e 6e 6f 74 | 20 62 65 20 6e 65 73 74 |s cannot| be nest|
|000005e0| 65 64 20 77 69 74 68 69 | 6e 20 6f 74 68 65 72 20 |ed withi|n other |
|000005f0| 47 45 54 53 55 4d 4d 41 | 52 59 20 66 75 6e 63 74 |GETSUMMA|RY funct|
|00000600| 69 6f 6e 73 2e 00 4f 6e | 6c 79 20 53 75 6d 6d 61 |ions..On|ly Summa|
|00000610| 72 79 20 66 69 65 6c 64 | 73 20 61 72 65 20 61 6c |ry field|s are al|
|00000620| 6c 6f 77 65 64 20 61 73 | 20 74 68 65 20 66 69 72 |lowed as| the fir|
|00000630| 73 74 20 61 72 67 75 6d | 65 6e 74 20 69 6e 20 61 |st argum|ent in a|
|00000640| 20 47 45 54 53 55 4d 4d | 41 52 59 20 66 75 6e 63 | GETSUMM|ARY func|
|00000650| 74 69 6f 6e 2e 00 54 68 | 65 20 73 65 63 6f 6e 64 |tion..Th|e second|
|00000660| 20 61 72 67 75 6d 65 6e | 74 20 69 6e 20 61 20 47 | argumen|t in a G|
|00000670| 45 54 53 55 4d 4d 41 52 | 59 20 66 75 6e 63 74 69 |ETSUMMAR|Y functi|
|00000680| 6f 6e 20 63 61 6e 6e 6f | 74 20 62 65 20 61 20 53 |on canno|t be a S|
|00000690| 75 6d 6d 61 72 79 20 66 | 69 65 6c 64 20 75 6e 6c |ummary f|ield unl|
|000006a0| 65 73 73 20 69 74 20 69 | 73 20 74 68 65 20 73 61 |ess it i|s the sa|
|000006b0| 6d 65 20 66 69 65 6c 64 | 20 61 73 20 74 68 65 20 |me field| as the |
|000006c0| 66 69 72 73 74 20 61 72 | 67 75 6d 65 6e 74 2e 00 |first ar|gument..|
|000006d0| 54 68 69 73 20 63 6f 6e | 73 74 61 6e 74 20 69 73 |This con|stant is|
|000006e0| 20 6e 6f 74 20 61 20 72 | 65 63 6f 67 6e 69 7a 65 | not a r|ecognize|
|000006f0| 64 20 73 74 61 74 75 73 | 20 66 6c 61 67 2e 00 54 |d status| flag..T|
|00000700| 68 65 20 73 75 6d 6d 61 | 72 69 7a 65 64 20 66 69 |he summa|rized fi|
|00000710| 65 6c 64 20 6d 75 73 74 | 20 62 65 20 61 20 4e 75 |eld must| be a Nu|
|00000720| 6d 62 65 72 2c 20 44 61 | 74 65 2c 20 54 69 6d 65 |mber, Da|te, Time|
|00000730| 20 6f 72 20 43 61 6c 63 | 75 6c 61 74 69 6f 6e 20 | or Calc|ulation |
|00000740| 66 69 65 6c 64 2e 00 54 | 68 69 73 20 66 69 65 6c |field..T|his fiel|
|00000750| 64 20 63 61 6e 6e 6f 74 | 20 62 65 20 75 73 65 64 |d cannot| be used|
|00000760| 20 68 65 72 65 20 62 65 | 63 61 75 73 65 20 69 74 | here be|cause it|
|00000770| 20 77 6f 75 6c 64 20 63 | 61 75 73 65 20 61 20 63 | would c|ause a c|
|00000780| 69 72 63 75 6c 61 72 20 | 64 65 66 69 6e 69 74 69 |ircular |definiti|
|00000790| 6f 6e 2e 00 50 65 72 6d | 61 6e 65 6e 74 6c 79 20 |on..Perm|anently |
|000007a0| 64 65 6c 65 74 65 20 74 | 68 65 20 73 65 6c 65 63 |delete t|he selec|
|000007b0| 74 65 64 20 66 69 65 6c | 64 28 73 29 20 61 6e 64 |ted fiel|d(s) and|
|000007c0| 20 41 4c 4c 20 6f 66 20 | 74 68 65 69 72 20 66 69 | ALL of |their fi|
|000007d0| 65 6c 64 20 64 61 74 61 | 3f 00 54 68 69 73 20 6e |eld data|?.This n|
|000007e0| 61 6d 65 20 63 61 6e 6e | 6f 74 20 62 65 20 75 73 |ame cann|ot be us|
|000007f0| 65 64 20 69 6e 20 61 20 | 63 61 6c 63 75 6c 61 74 |ed in a |calculat|
|00000800| 69 6f 6e 20 66 6f 72 6d | 75 6c 61 20 62 65 63 61 |ion form|ula beca|
|00000810| 75 73 65 20 69 74 0a 20 | 20 2d 20 63 6f 6e 74 61 |use it. | - conta|
|00000820| 69 6e 73 3a 20 2b 20 2d | 20 2a 20 2f 20 5e 20 26 |ins: + -| * / ^ &|
|00000830| 20 3d 20 3c 20 3e 20 28 | 20 2c 20 29 20 22 20 3a | = < > (| , ) " :|
|00000840| 3a 0a 20 20 2d 20 63 6f | 6e 74 61 69 6e 73 3a 20 |:.  - co|ntains: |
|00000850| 41 4e 44 2c 20 4f 52 2c | 20 58 4f 52 2c 20 4e 4f |AND, OR,| XOR, NO|
|00000860| 54 2c 20 6f 72 0a 20 20 | 2d 20 62 65 67 69 6e 73 |T, or.  |- begins|
|00000870| 20 77 69 74 68 20 61 20 | 64 69 67 69 74 20 6f 72 | with a |digit or|
|00000880| 20 61 20 70 65 72 69 6f | 64 2c 20 6f 72 0a 20 20 | a perio|d, or.  |
|00000890| 2d 20 68 61 73 20 74 68 | 65 20 73 61 6d 65 20 6e |- has th|e same n|
|000008a0| 61 6d 65 20 61 73 20 61 | 20 66 75 6e 63 74 69 6f |ame as a| functio|
|000008b0| 6e 2e 0a 50 72 6f 63 65 | 65 64 20 61 6e 79 77 61 |n..Proce|ed anywa|
|000008c0| 79 3f 00 57 68 65 6e 20 | 63 68 61 6e 67 69 6e 67 |y?.When |changing|
|000008d0| 20 74 68 65 20 66 69 65 | 6c 64 20 74 79 70 65 20 | the fie|ld type |
|000008e0| 66 72 6f 6d 20 54 65 78 | 74 20 74 6f 20 4e 75 6d |from Tex|t to Num|
|000008f0| 62 65 72 2c 20 44 61 74 | 65 2c 20 6f 72 20 54 69 |ber, Dat|e, or Ti|
|00000900| 6d 65 2c 20 46 69 6c 65 | 4d 61 6b 65 72 20 77 69 |me, File|Maker wi|
|00000910| 6c 6c 20 70 75 74 20 74 | 68 65 20 64 61 74 61 20 |ll put t|he data |
|00000920| 6f 6e 20 6f 6e 65 20 6c | 69 6e 65 2e 20 20 41 6e |on one l|ine.  An|
|00000930| 79 20 64 61 74 61 20 61 | 66 74 65 72 20 74 68 65 |y data a|fter the|
|00000940| 20 66 69 72 73 74 20 32 | 35 35 20 63 68 61 72 61 | first 2|55 chara|
|00000950| 63 74 65 72 73 20 77 69 | 6c 6c 20 62 65 20 70 65 |cters wi|ll be pe|
|00000960| 72 6d 61 6e 65 6e 74 6c | 79 20 64 65 6c 65 74 65 |rmanentl|y delete|
|00000970| 64 2e 20 20 50 72 6f 63 | 65 65 64 20 61 6e 79 77 |d.  Proc|eed anyw|
|00000980| 61 79 3f 00 57 68 65 6e | 20 63 68 61 6e 67 69 6e |ay?.When| changin|
|00000990| 67 20 74 68 65 20 66 69 | 65 6c 64 20 74 79 70 65 |g the fi|eld type|
|000009a0| 20 74 6f 20 43 61 6c 63 | 75 6c 61 74 69 6f 6e 20 | to Calc|ulation |
|000009b0| 6f 72 20 53 75 6d 6d 61 | 72 79 2c 20 46 69 6c 65 |or Summa|ry, File|
|000009c0| 4d 61 6b 65 72 20 77 69 | 6c 6c 20 72 65 70 6c 61 |Maker wi|ll repla|
|000009d0| 63 65 20 61 6e 79 20 64 | 61 74 61 20 69 6e 20 74 |ce any d|ata in t|
|000009e0| 68 65 20 66 69 65 6c 64 | 20 77 69 74 68 20 74 68 |he field| with th|
|000009f0| 65 20 72 65 73 75 6c 74 | 20 6f 66 20 74 68 65 20 |e result| of the |
|00000a00| 66 6f 72 6d 75 6c 61 2e | 20 20 50 72 6f 63 65 65 |formula.|  Procee|
|00000a10| 64 20 61 6e 79 77 61 79 | 3f 00 57 68 65 6e 20 63 |d anyway|?.When c|
|00000a20| 68 61 6e 67 69 6e 67 20 | 74 6f 20 6f 72 20 66 72 |hanging |to or fr|
|00000a30| 6f 6d 20 61 20 43 6f 6e | 74 61 69 6e 65 72 20 66 |om a Con|tainer f|
|00000a40| 69 65 6c 64 2c 20 61 6c | 6c 20 64 61 74 61 20 69 |ield, al|l data i|
|00000a50| 6e 20 74 68 65 20 66 69 | 65 6c 64 20 77 69 6c 6c |n the fi|eld will|
|00000a60| 20 62 65 20 6c 6f 73 74 | 2e 20 20 50 72 6f 63 65 | be lost|.  Proce|
|00000a70| 65 64 20 61 6e 79 77 61 | 79 3f 00 54 68 65 20 66 |ed anywa|y?.The f|
|00000a80| 69 65 6c 64 20 22 25 30 | 22 20 68 61 73 20 62 65 |ield "%0|" has be|
|00000a90| 65 6e 20 64 65 66 69 6e | 65 64 20 74 6f 20 68 61 |en defin|ed to ha|
|00000aa0| 76 65 20 6d 6f 72 65 20 | 72 65 70 65 74 69 74 69 |ve more |repetiti|
|00000ab0| 6f 6e 73 20 74 68 61 6e | 20 74 68 65 20 66 69 65 |ons than| the fie|
|00000ac0| 6c 64 20 22 25 31 22 20 | 69 6e 20 74 68 69 73 20 |ld "%1" |in this |
|00000ad0| 66 69 6c 65 2e 20 20 41 | 73 20 61 20 72 65 73 75 |file.  A|s a resu|
|00000ae0| 6c 74 2c 20 73 6f 6d 65 | 20 64 61 74 61 20 6d 61 |lt, some| data ma|
|00000af0| 79 20 6e 6f 74 20 62 65 | 20 63 6f 70 69 65 64 20 |y not be| copied |
|00000b00| 77 68 65 6e 20 61 20 6c | 6f 6f 6b 75 70 20 69 73 |when a l|ookup is|
|00000b10| 20 70 65 72 66 6f 72 6d | 65 64 2e 20 20 50 72 6f | perform|ed.  Pro|
|00000b20| 63 65 65 64 20 61 6e 79 | 77 61 79 3f 00 57 68 65 |ceed any|way?.Whe|
|00000b30| 6e 20 63 68 61 6e 67 69 | 6e 67 20 74 6f 20 6f 72 |n changi|ng to or|
|00000b40| 20 66 72 6f 6d 20 61 20 | 47 6c 6f 62 61 6c 20 66 | from a |Global f|
|00000b50| 69 65 6c 64 2c 20 61 6c | 6c 20 64 61 74 61 20 69 |ield, al|l data i|
|00000b60| 6e 20 74 68 65 20 66 69 | 65 6c 64 20 77 69 6c 6c |n the fi|eld will|
|00000b70| 20 62 65 20 6c 6f 73 74 | 2e 20 20 50 72 6f 63 65 | be lost|.  Proce|
|00000b80| 65 64 20 61 6e 79 77 61 | 79 3f 00 54 68 65 20 73 |ed anywa|y?.The s|
|00000b90| 75 6d 6d 61 72 69 7a 65 | 64 20 66 69 65 6c 64 20 |ummarize|d field |
|00000ba0| 6d 75 73 74 20 62 65 20 | 61 20 54 65 78 74 2c 20 |must be |a Text, |
|00000bb0| 4e 75 6d 62 65 72 2c 20 | 44 61 74 65 2c 20 54 69 |Number, |Date, Ti|
|00000bc0| 6d 65 2c 20 47 6c 6f 62 | 61 6c 20 6f 72 20 43 61 |me, Glob|al or Ca|
|00000bd0| 6c 63 75 6c 61 74 69 6f | 6e 20 66 69 65 6c 64 2e |lculatio|n field.|
|00000be0| 00 54 68 65 20 72 65 6c | 61 74 69 6f 6e 73 68 69 |.The rel|ationshi|
|00000bf0| 70 20 6e 61 6d 65 20 22 | 25 31 22 20 69 73 20 6e |p name "|%1" is n|
|00000c00| 6f 74 20 75 6e 69 71 75 | 65 2e 00 52 65 6c 61 74 |ot uniqu|e..Relat|
|00000c10| 69 6f 6e 73 68 69 70 20 | 6e 61 6d 65 73 20 6d 75 |ionship |names mu|
|00000c20| 73 74 20 62 65 20 62 65 | 74 77 65 65 6e 20 31 20 |st be be|tween 1 |
|00000c30| 61 6e 64 20 36 30 20 63 | 68 61 72 61 63 74 65 72 |and 60 c|haracter|
|00000c40| 73 20 61 6e 64 20 6d 61 | 79 20 6e 6f 74 20 63 6f |s and ma|y not co|
|00000c50| 6e 74 61 69 6e 20 61 20 | 22 3a 22 2e 20 20 50 6c |ntain a |":".  Pl|
|00000c60| 65 61 73 65 20 74 79 70 | 65 20 69 6e 20 61 20 76 |ease typ|e in a v|
|00000c70| 61 6c 69 64 20 72 65 6c | 61 74 69 6f 6e 73 68 69 |alid rel|ationshi|
|00000c80| 70 20 6e 61 6d 65 2e 00 | 56 61 6c 75 65 20 6c 69 |p name..|Value li|
|00000c90| 73 74 20 6e 61 6d 65 73 | 20 6d 75 73 74 20 62 65 |st names| must be|
|00000ca0| 20 62 65 74 77 65 65 6e | 20 31 20 61 6e 64 20 36 | between| 1 and 6|
|00000cb0| 30 20 63 68 61 72 61 63 | 74 65 72 73 20 61 6e 64 |0 charac|ters and|
|00000cc0| 20 6d 75 73 74 20 62 65 | 20 75 6e 69 71 75 65 2e | must be| unique.|
|00000cd0| 0a 50 6c 65 61 73 65 20 | 65 6e 74 65 72 20 61 20 |.Please |enter a |
|00000ce0| 76 61 6c 69 64 20 76 61 | 6c 75 65 20 6c 69 73 74 |valid va|lue list|
|00000cf0| 20 6e 61 6d 65 20 2e 00 | 50 65 72 6d 61 6e 65 6e | name ..|Permanen|
|00000d00| 74 6c 79 20 64 65 6c 65 | 74 65 20 74 68 65 20 73 |tly dele|te the s|
|00000d10| 65 6c 65 63 74 65 64 20 | 25 31 3f 00 54 68 65 20 |elected |%1?.The |
|00000d20| 66 69 65 6c 64 20 74 79 | 70 65 20 6f 66 20 22 25 |field ty|pe of "%|
|00000d30| 30 22 20 63 61 6e 6e 6f | 74 20 62 65 20 63 68 61 |0" canno|t be cha|
|00000d40| 6e 67 65 64 20 62 65 63 | 61 75 73 65 20 22 25 30 |nged bec|ause "%0|
|00000d50| 22 20 69 73 20 75 73 65 | 64 20 62 79 20 74 68 65 |" is use|d by the|
|00000d60| 20 72 65 6c 61 74 69 6f | 6e 73 68 69 70 20 22 25 | relatio|nship "%|
|00000d70| 31 22 2e 00 54 68 65 20 | 63 61 6c 63 75 6c 61 74 |1"..The |calculat|
|00000d80| 69 6f 6e 20 22 25 31 22 | 20 63 61 6e 6e 6f 74 20 |ion "%1"| cannot |
|00000d90| 62 65 20 73 74 6f 72 65 | 64 20 6f 72 20 69 6e 64 |be store|d or ind|
|00000da0| 65 78 65 64 20 62 65 63 | 61 75 73 65 20 69 74 20 |exed bec|ause it |
|00000db0| 72 65 66 65 72 65 6e 63 | 65 73 20 61 20 72 65 6c |referenc|es a rel|
|00000dc0| 61 74 65 64 20 66 69 65 | 6c 64 2c 20 61 20 47 6c |ated fie|ld, a Gl|
|00000dd0| 6f 62 61 6c 20 66 69 65 | 6c 64 2c 20 61 20 53 75 |obal fie|ld, a Su|
|00000de0| 6d 6d 61 72 79 20 66 69 | 65 6c 64 20 6f 72 20 61 |mmary fi|eld or a|
|00000df0| 6e 20 75 6e 73 74 6f 72 | 65 64 20 43 61 6c 63 75 |n unstor|ed Calcu|
|00000e00| 6c 61 74 69 6f 6e 20 69 | 6e 20 69 74 73 20 66 6f |lation i|n its fo|
|00000e10| 72 6d 75 6c 61 2e 00 54 | 68 69 73 20 72 65 6c 61 |rmula..T|his rela|
|00000e20| 74 69 6f 6e 73 68 69 70 | 20 77 69 6c 6c 20 6e 6f |tionship| will no|
|00000e30| 74 20 77 6f 72 6b 20 62 | 65 63 61 75 73 65 20 74 |t work b|ecause t|
|00000e40| 68 65 20 66 69 65 6c 64 | 20 22 25 31 22 20 63 61 |he field| "%1" ca|
|00000e50| 6e 6e 6f 74 20 62 65 20 | 69 6e 64 65 78 65 64 2e |nnot be |indexed.|
|00000e60| 20 20 50 72 6f 63 65 65 | 64 20 61 6e 79 77 61 79 |  Procee|d anyway|
|00000e70| 3f 00 22 25 30 22 2c 20 | 77 68 69 63 68 20 69 73 |?."%0", |which is|
|00000e80| 20 61 20 6d 61 74 63 68 | 20 66 69 65 6c 64 20 69 | a match| field i|
|00000e90| 6e 20 74 68 69 73 20 72 | 65 6c 61 74 69 6f 6e 73 |n this r|elations|
|00000ea0| 68 69 70 2c 20 69 73 20 | 61 6c 73 6f 20 74 68 65 |hip, is |also the|
|00000eb0| 20 64 65 73 74 69 6e 61 | 74 69 6f 6e 20 6f 66 20 | destina|tion of |
|00000ec0| 61 20 6c 6f 6f 6b 75 70 | 2e 20 54 68 69 73 20 63 |a lookup|. This c|
|00000ed0| 69 72 63 75 6c 61 72 20 | 64 65 66 69 6e 69 74 69 |ircular |definiti|
|00000ee0| 6f 6e 20 69 73 20 6e 6f | 74 20 61 6c 6c 6f 77 65 |on is no|t allowe|
|00000ef0| 64 2e 00 43 68 65 63 6b | 69 6e 67 20 66 6f 72 20 |d..Check|ing for |
|00000f00| 75 6e 69 71 75 65 20 6f | 72 20 65 78 69 73 74 69 |unique o|r existi|
|00000f10| 6e 67 20 76 61 6c 75 65 | 73 20 77 69 6c 6c 20 6e |ng value|s will n|
|00000f20| 6f 74 20 77 6f 72 6b 20 | 62 65 63 61 75 73 65 20 |ot work |because |
|00000f30| 74 68 65 20 66 69 65 6c | 64 20 22 25 31 22 20 63 |the fiel|d "%1" c|
|00000f40| 61 6e 6e 6f 74 20 62 65 | 20 69 6e 64 65 78 65 64 |annot be| indexed|
|00000f50| 2e 20 20 50 72 6f 63 65 | 65 64 20 61 6e 79 77 61 |.  Proce|ed anywa|
|00000f60| 79 3f 00 54 68 69 73 20 | 72 65 6c 61 74 69 6f 6e |y?.This |relation|
|00000f70| 73 68 69 70 20 77 69 6c | 6c 20 6e 6f 74 20 77 6f |ship wil|l not wo|
|00000f80| 72 6b 20 62 65 63 61 75 | 73 65 20 74 68 65 20 66 |rk becau|se the f|
|00000f90| 69 65 6c 64 20 22 25 31 | 22 20 69 73 20 61 20 63 |ield "%1|" is a c|
|00000fa0| 6f 6e 74 61 69 6e 65 72 | 20 66 69 65 6c 64 2e 20 |ontainer| field. |
|00000fb0| 20 50 72 6f 63 65 65 64 | 20 61 6e 79 77 61 79 3f | Proceed| anyway?|
|00000fc0| 00 22 25 31 22 20 61 6e | 64 20 22 25 30 22 20 20 |."%1" an|d "%0"  |
|00000fd0| 61 72 65 20 69 6e 63 6f | 6d 70 61 74 69 62 6c 65 |are inco|mpatible|
|00000fe0| 20 66 69 65 6c 64 73 2e | 20 20 4f 6e 6c 79 20 6f | fields.|  Only o|
|00000ff0| 6e 65 20 6f 66 20 74 68 | 65 6d 20 69 73 20 61 20 |ne of th|em is a |
|00001000| 63 6f 6e 74 61 69 6e 65 | 72 20 66 69 65 6c 64 2e |containe|r field.|
|00001010| 20 20 50 72 6f 63 65 65 | 64 20 61 6e 79 77 61 79 |  Procee|d anyway|
|00001020| 3f 00 76 61 6c 75 65 20 | 6c 69 73 74 28 73 29 00 |?.value |list(s).|
|00001030| 72 65 6c 61 74 69 6f 6e | 73 68 69 70 28 73 29 00 |relation|ship(s).|
|00001040| 54 68 69 73 20 76 61 6c | 75 65 20 6c 69 73 74 20 |This val|ue list |
|00001050| 77 69 6c 6c 20 6e 6f 74 | 20 77 6f 72 6b 20 62 65 |will not| work be|
|00001060| 63 61 75 73 65 20 74 68 | 65 20 66 69 65 6c 64 20 |cause th|e field |
|00001070| 22 25 31 22 20 63 61 6e | 6e 6f 74 20 62 65 20 69 |"%1" can|not be i|
|00001080| 6e 64 65 78 65 64 2e 20 | 20 50 72 6f 63 65 65 64 |ndexed. | Proceed|
|00001090| 20 61 6e 79 77 61 79 3f | 00                      | anyway?|.       |
+--------+-------------------------+-------------------------+--------+--------+