Date: Mon, 23 Jul 2001 15:11:31 +0900
From: "tec" <who@sub.example.jp>
This is a multi-part message in MIME format.
------=_NextPart_000_0013_01C11389.C13FB670
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0014_01C11389.C145D0F0"
------=_NextPart_001_0014_01C11389.C145D0F0
Content-Type: text/plain;
charset="iso-2022-jp"
Content-Transfer-Encoding: 7bit
MSDEの初心者です。
1) 連結を表示したフォームでデーターの追加・編集がしたいと思っています。
テーブル同士で連結している時
例 テーブル名 a 出勤 名簿
フィールド名 a NO NO a 主キーで連結している
日付 氏名
工程 グループ
上記のテーブルからビューをつくります。
例 出勤ビュー
NO a入力 主キーで連結している
氏名 →名簿テーブルから呼出し
グループ →名簿テーブルから呼出し
工程 →入力
ビューでは入力・編集が出来ませんので上記ビューからフォームを作成すると検索の
みにしか使えません。
しかしテーブルからフォームを作るとデーターの追加・編集は出来ても、連結先から
持ってきたいフィールドがフォーム上に表示できません。どうしたらよいのでしょう
か。
尚、NOの入力の時にプルダウンメニューを使うのはフォームの設計の時にリストボッ
クスを貼り付けてつくりました。
------=_NextPart_001_0014_01C11389.C145D0F0
Content-Type: text/html;
charset="iso-2022-jp"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-2022-jp">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2><FONT size=3D3><FONT =
size=3D2>MSDE=1B$B$N=3Di?4<T$G$9!#=1B(B</FONT> </FONT>
<P class=3DMsoNormal><SPAN lang=3DEN-US>1)</SPAN><SPAN=20
style=3D"FONT-FAMILY: '=1B$B#M#S=1B(B =1B$BL@D+=1B(B'; =
mso-ascii-font-family: Century; mso-hansi-font-family: =
Century">=1B$B!!O"7k$rI=3D<($7$?%U%)!<%`$G%G!<%?!<$NDI2C!&JT=3D8$,$7$?$$$=
H;W$C$F$$$^$9!#=1B(B</SPAN></P>
<P class=3DMsoNormal=20
style=3D"TEXT-INDENT: 21pt; mso-char-indent-count: 2.0; =
mso-char-indent-size: 10.5pt"><SPAN=20
style=3D"FONT-FAMILY: '=1B$B#M#S=1B(B =1B$BL@D+=1B(B'; =
mso-ascii-font-family: Century; mso-hansi-font-family: =
Century">=1B$B%F!<%V%kF1;N$GO"7k$7$F$$$k;~=1B(B</SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-FAMILY: '=1B$B#M#S=1B(B =1B$BL@D+=1B(B'; =
mso-ascii-font-family: Century; mso-hansi-font-family: =
Century">=1B$BNc!!%F!<%V%kL>!!=1B(B</SPAN><SPAN=20
lang=3DEN-US=20
style=3D"FONT-FAMILY: Wingdings; mso-ascii-font-family: 'Times New =
Roman'; mso-hansi-font-family: 'Times New Roman'; mso-font-kerning: 0pt; =
mso-char-type: symbol; mso-symbol-font-family: Wingdings"><SPAN=20
style=3D"mso-char-type: symbol; mso-symbol-font-family: =
Wingdings">à</SPAN></SPAN><SPAN=20
style=3D"FONT-FAMILY: '=1B$B#M#S=1B(B =1B$BL@D+=1B(B'; =
mso-ascii-font-family: Century; mso-hansi-font-family: =
Century">=1B$B!!!!=3DP6P!!!!!!L>Jm=1B(B</SPAN></P>
<P class=3DMsoNormal><SPAN style=3D"POSITION: relative; mso-ignore: =
vglayout"><SPAN=20
style=3D"LEFT: 23px; WIDTH: 435px; POSITION: absolute; TOP: -1px; =
HEIGHT: 3px"><IMG=20
height=3D3 src=3D"cid:001101c1133e$513fa470$0b01a8c0@ws01" width=3D435=20
v:shapes=3D"_x0000_s1026"></SPAN></SPAN><SPAN=20
style=3D"FONT-FAMILY: '=1B$B#M#S=1B(B =1B$BL@D+=1B(B'; =
mso-ascii-font-family: Century; mso-hansi-font-family: =
Century">=1B$B!!!!%U%#!<%k%IL>!!=1B(B</SPAN><SPAN=20
lang=3DEN-US=20
style=3D"FONT-FAMILY: Wingdings; mso-ascii-font-family: 'Times New =
Roman'; mso-hansi-font-family: 'Times New Roman'; mso-font-kerning: 0pt; =
mso-char-type: symbol; mso-symbol-font-family: Wingdings"><SPAN=20
style=3D"mso-char-type: symbol; mso-symbol-font-family: =
Wingdings">à</SPAN></SPAN><SPAN=20
style=3D"FONT-FAMILY: '=1B$B#M#S=1B(B =1B$BL@D+=1B(B'; =
mso-ascii-font-family: Century; mso-hansi-font-family: =
Century">=1B$B!!=1B(B</SPAN><SPAN=20
lang=3DEN-US>NO<SPAN=20
style=3D"mso-spacerun: yes"> =20
</SPAN>NO</SPAN><SPAN=20
style=3D"FONT-FAMILY: '=1B$B#M#S=1B(B =1B$BL@D+=1B(B'; =
mso-ascii-font-family: Century; mso-hansi-font-family: =
Century">=1B$B!!=1B(B</SPAN>=20
<SPAN lang=3DEN-US=20
style=3D"FONT-FAMILY: Wingdings; mso-ascii-font-family: 'Times New =
Roman'; mso-hansi-font-family: 'Times New Roman'; mso-font-kerning: 0pt; =
mso-char-type: symbol; mso-symbol-font-family: Wingdings"><SPAN=20
style=3D"mso-char-type: symbol; mso-symbol-font-family: =
Wingdings">à</SPAN></SPAN><SPAN=20
lang=3DEN-US> </SPAN><SPAN=20
style=3D"FONT-FAMILY: '=1B$B#M#S=1B(B =1B$BL@D+=1B(B'; =
mso-ascii-font-family: Century; mso-hansi-font-family: =
Century">=1B$B<g%-!<$GO"7k$7$F$$$k=1B(B</SPAN></P>
<P class=3DMsoNormal style=3D"TEXT-INDENT: 115.5pt"><SPAN=20
style=3D"FONT-FAMILY: '=1B$B#M#S=1B(B =1B$BL@D+=1B(B'; =
mso-ascii-font-family: Century; mso-hansi-font-family: =
Century">=1B$BF|IU!!!!!!;aL>=1B(B</SPAN></P>
<P class=3DMsoNormal style=3D"TEXT-INDENT: 115.5pt"><SPAN=20
style=3D"FONT-FAMILY: '=1B$B#M#S=1B(B =1B$BL@D+=1B(B'; =
mso-ascii-font-family: Century; mso-hansi-font-family: =
Century">=1B$B9)Dx!!!!!!%0%k!<%W=1B(B</SPAN></P>
<P class=3DMsoNormal style=3D"TEXT-ALIGN: left" align=3Dleft><SPAN=20
style=3D"Z-INDEX: 1; POSITION: relative; mso-ignore: vglayout"><SPAN=20
style=3D"LEFT: 23px; WIDTH: 435px; POSITION: absolute; TOP: -1px; =
HEIGHT: 3px"><IMG=20
height=3D3 src=3D"cid:001201c1133e$514bd970$0b01a8c0@ws01" width=3D435=20
v:shapes=3D"_x0000_s1027"></SPAN></SPAN><SPAN=20
style=3D"FONT-FAMILY: '=1B$B#M#S=1B(B =1B$BL@D+=1B(B'; =
mso-ascii-font-family: Century; mso-hansi-font-family: =
Century">=1B$B>e5-$N%F!<%V%k$+$i%S%e!<$r$D$/$j$^$9!#=1B(B</SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-FAMILY: '=1B$B#M#S=1B(B =1B$BL@D+=1B(B'; =
mso-ascii-font-family: Century; mso-hansi-font-family: =
Century">=1B$BNc!!=3DP6P%S%e!<!!!!!!=1B(B</SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-FAMILY: '=1B$B#M#S=1B(B =1B$BL@D+=1B(B'; =
mso-ascii-font-family: Century; mso-hansi-font-family: =
Century">=1B$B!!!!=1B(B</SPAN><SPAN=20
lang=3DEN-US>NO<SPAN=20
style=3D"mso-spacerun: yes"> =20
</SPAN></SPAN><SPAN=20
style=3D"FONT-FAMILY: '=1B$B#M#S=1B(B =1B$BL@D+=1B(B'; =
mso-ascii-font-family: Century; mso-hansi-font-family: =
Century">=1B$B!!=1B(B</SPAN>=20
<SPAN lang=3DEN-US=20
style=3D"FONT-FAMILY: Wingdings; mso-ascii-font-family: 'Times New =
Roman'; mso-hansi-font-family: 'Times New Roman'; mso-font-kerning: 0pt; =
mso-char-type: symbol; mso-symbol-font-family: Wingdings"><SPAN=20
style=3D"mso-char-type: symbol; mso-symbol-font-family: =
Wingdings">à</SPAN></SPAN><SPAN=20
style=3D"FONT-FAMILY: '=1B$B#M#S=1B(B =1B$BL@D+=1B(B'; =
mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times =
New Roman'; mso-font-kerning: =
0pt">=1B$BF~NO!!!!!!!!!!!!!!!!!!!!=1B(B</SPAN>=20
<SPAN=20
style=3D"FONT-FAMILY: '=1B$B#M#S=1B(B =1B$BL@D+=1B(B'; =
mso-ascii-font-family: Century; mso-hansi-font-family: =
Century">=1B$B<g%-!<$GO"7k$7$F$$$k=1B(B</SPAN></P>
<P class=3DMsoNormal=20
style=3D"TEXT-INDENT: 42pt; TEXT-ALIGN: left; mso-char-indent-count: =
4.0; mso-char-indent-size: 10.5pt"=20
align=3Dleft><SPAN=20
style=3D"FONT-FAMILY: '=1B$B#M#S=1B(B =1B$BL@D+=1B(B'; =
mso-ascii-font-family: Century; mso-hansi-font-family: =
Century">=1B$B;aL>!!!!!!!!!!"*L>Jm%F!<%V%k$+$i8F=3DP$7=1B(B</SPAN></P>
<P class=3DMsoNormal=20
style=3D"TEXT-INDENT: 42pt; mso-char-indent-count: 4.0; =
mso-char-indent-size: 10.5pt"><SPAN=20
style=3D"FONT-FAMILY: '=1B$B#M#S=1B(B =1B$BL@D+=1B(B'; =
mso-ascii-font-family: Century; mso-hansi-font-family: =
Century">=1B$B%0%k!<%W!!!!!!"*L>Jm%F!<%V%k$+$i8F=3DP$7=1B(B</SPAN></P>
<P class=3DMsoNormal style=3D"TEXT-ALIGN: left" align=3Dleft><SPAN=20
style=3D"FONT-FAMILY: '=1B$B#M#S=1B(B =1B$BL@D+=1B(B'; =
mso-ascii-font-family: Century; mso-hansi-font-family: =
Century">=1B$B!!!!9)Dx!!!!!!!!!!"*F~NO!!=1B(B</SPAN></P>
<P class=3DMsoNormal style=3D"TEXT-ALIGN: left" align=3Dleft><SPAN=20
lang=3DEN-US> <?xml:namespace prefix =3D o ns =3D=20
"urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></P>
<P class=3DMsoNormal style=3D"TEXT-ALIGN: left" align=3Dleft><SPAN=20
style=3D"FONT-FAMILY: '=1B$B#M#S=1B(B =1B$BL@D+=1B(B'; =
mso-ascii-font-family: Century; mso-hansi-font-family: =
Century">=1B$B%S%e!<$G$OF~NO!&JT=3D8$,=3DPMh$^$;$s$N$G>e5-%S%e!<$+$i%U%)!=
<%`$r:n@.$9$k$H8!:w$N$_$K$7$+;H$($^$;$s!#=1B(B</SPAN></P>
<P class=3DMsoNormal style=3D"TEXT-ALIGN: left" align=3Dleft><SPAN=20
style=3D"FONT-FAMILY: '=1B$B#M#S=1B(B =1B$BL@D+=1B(B'; =
mso-ascii-font-family: Century; mso-hansi-font-family: =
Century">=1B$B$7$+$7%F!<%V%k$+$i%U%)!<%`$r:n$k$H%G!<%?!<$NDI2C!&JT=3D8$O=3D=
PMh$F$b!"O"7k@h$+$i;}$C$F$-$?$$%U%#!<%k%I$,%U%)!<%`>e$KI=3D<($G$-$^$;$s!#=
$I$&$7$?$i$h$$$N$G$7$g$&$+!#=1B(B</SPAN></P>
<P class=3DMsoNormal style=3D"TEXT-ALIGN: left" align=3Dleft><SPAN=20
style=3D"FONT-FAMILY: '=1B$B#M#S=1B(B =1B$BL@D+=1B(B'; =
mso-ascii-font-family: Century; mso-hansi-font-family: =
Century">=1B$B>0!"=1B(B</SPAN><SPAN=20
lang=3DEN-US>NO</SPAN><SPAN=20
style=3D"FONT-FAMILY: '=1B$B#M#S=1B(B =1B$BL@D+=1B(B'; =
mso-ascii-font-family: Century; mso-hansi-font-family: =
Century">=1B$B$NF~NO$N;~$K%W%k%@%&%s%a%K%e!<$r;H$&$N$O%U%)!<%`$N@_7W$N;~$=
K%j%9%H%\%C%/%9$rE=3D$jIU$1$F$D$/$j$^$7$?!#=1B(B</SPAN></P></FONT></DIV><=
/BODY></HTML>
------=_NextPart_001_0014_01C11389.C145D0F0--
------=_NextPart_000_0013_01C11389.C13FB670
Content-Type: image/gif;
name="clip_image001.gif"
Content-Transfer-Encoding: base64
Content-ID: <001101c1133e$513fa470$0b01a8c0@ws01>
R0lGODlhswEDAHcBMSH+GlNvZnR3YXJlOiBNaWNyb3NvZnQgT2ZmaWNlACH5BAEAAAEALAEAAQCx
AQEAgAAAAIGBgQIShI+py+0Po5y02ouz3rz7D34FADs=
------=_NextPart_000_0013_01C11389.C13FB670
Content-Type: image/gif;
name="clip_image002.gif"
Content-Transfer-Encoding: base64
Content-ID: <001201c1133e$514bd970$0b01a8c0@ws01>
R0lGODlhswEDAHcBMSH+GlNvZnR3YXJlOiBNaWNyb3NvZnQgT2ZmaWNlACH5BAEAAAEALAEAAQCx
AQEAgAAAAIGBgQIShI+py+0Po5y02ouz3rz7D34FADs=
------=_NextPart_000_0013_01C11389.C13FB670--
| [MSDE/SQLServerに関して、今、どんなことにお困りですか？] |
| よろしければお困りの内容を、電子メールで教えて下さい。 |
|
質問を電子メールで作成する
|
[ウィンドを閉じる][MSDE/SQLServer FAQ ][MSDE / MSDE2000 技術サポート情報一覧]
|
