I have a couple questions about multi-tabled windows.

Where is the documentation?

It seems that you can't use multi-valued fields from the secondary table - as well as symbolics. Is this true? I can understand symbolics, but I'm not sure what the problem is multivalued fields.

Thanks

Jeff

Hopefully this posted OK. It's an old document I had written by someone from Bellvue's tech support staff a few years back. I'd post credit, but it doesn't say who wrote it.

If it's unreadable, post your e-mail address and I'll mail out a copy.

apk@sprezzatura.com

Sprezzatura, Inc.

                     CREATING MULTI-TABLE WINDOWS

Using the One-to-Many Relationship:

At TCL type MAKETABLE.

Here's the layout of INV_ORD_HDR2

Column Name                T   Pos       Data Type     Heading      Len    J   S/M
--------------------------------------------------------------------------------------------
OrdNo	                    F      0			OrdNo	        10    R    S
Date	                    F      1			Date	        10    L    S
Company	                    F      2			Company     15    L    S
Contact	                    F      3			Contact        15    L    S
PartNo	                    F      4			PartNo         10    R    S
Qty                                F      5			Qty 	        10    L    S
		 to creating Data Portion Now?

At TCL type MAKETABLE.

Here's the layout of INV_ORD_DET2

Column Name               T   Pos       Data Type        Heading      Len    J   S/M
--------------------------------------------------------------------------------------------
OrdNo	                    F    0*1			OrdNo	             10    R    S
PartNo	                    F    0*2			PartNo             10    R    S
Qty	                    F      1			Qty 	             10    L    S
Descrip	                    F      2			Descrip             15    L    S
		 to creating Data Portion Now?

At TCL type PAINT INV_ORD_WIN2. Use table. Then add the tables, in the master-slave order and you'll get message P9 saying you must create the relationship. Use the menus to do this by F10, then Multi-Table, then Table Relations. The layout of this will be:

	Table 1 INV_ORD_HDR2              Table 2 INV_ORD_DET2
	Column(s) in table 1             =         Column(s) in table 2
 	    ORDNO                                         ORDNO
Direction One-to-Many

F9 to save, then to remove that window and go back to the window you are painting. Now you have to re-add the tables to the window. F10, Tables, Add Table, and choose these 2 tables again, in the order you want them to be Master-Slave. Then Shift-F9, to do a Quick Paint and from the popup that appears choose:

	INV_ORD_HDR2		ORDNO
				DATE
				COMPANY
				CONTACT

	INV_ORD_DET2		PARTNO
				QTY

PARTNO and QTY should appear with multivalue line and if you hit F10-Advanced-Groupings, they will be AMV Group 1.

Shift-F1 to Test Run. to continue, when it asks about the data tables.

Using the One-to-One Relationship:

I created a 3 table window in order to try and get my data to Fourth Normalized Form. This is how I set it up:

At TCL type MAKETABLE.

Here's the layout of ORDER_HDR

	Column Name		T	Pos	Data Type	Heading	Len	J	S/M
-------------------------------------------------------------------------------------------------------------------------------------
	OrdNo				F	  0			OrdNo		10	R	 S
	Date				F	  1			Date		10	L	 S
	CustNo			F	  2			CustNo	10	L	 S
	PartNo				F	  3			PartNo		10	R	 S
			 to Create Data Portion Now?

At TCL type MAKETABLE.

Here's the layout of CUSTOMER

	Column Name		T	Pos	Data Type	Heading	Len	J	S/M
-------------------------------------------------------------------------------------------------------------------------------------
	CustNo			F	  0			CustNo	15	L	 S
	Name				F	  1			Name		15	L	 S
	Addr				F	  2			Addr		15	L	 S
	Phone				F	  3			Phone		10	R	 S
	Contact			F	  4			Contact	15	L	 S
			 to Create Data Portion Now?

At TCL type PAINT ORDER_WINDOW. Use table. Then add the tables, in the master-slave order and you'll get message P9 saying you must create the relationship. Use the menus to do this by F10, then Multi-Table, then Table Relations. The layout of this will be:

	Table 1   ORDER_HDR              Table 2   CUSTOMER
	Column(s) in table 1                   = Column(s) in table 2
 	    CUSTNO                                        CUSTNO
Direction One-to-One

F9 to save, then to remove that window and go back to the window you are painting. Now you have to re-add the tables to the window. F10, Tables, Add Table, and choose these 2 tables again, in the order you want them to be Master-Slave. Then Shift-F9, to do a Quick Paint and from the popup that appears choose:

	ORDER_HDR		ORDNO
				DATE
				CUSTNO

	CUSTOMER		NAME
				CONTACT

This will save the custno in the order_hdr table and allow you to pull up that information when entering orders.

I have found that if you try and change relationships between tables, or change which table you are calling the prompt from, your Multi-table window won't work properly. I have entered this into the problem tracker as a bug. If you would like to call on the status of it the number is 231.

</code>

View this thread on the forum...