More Multi-Table info (AREV Specific)
At 31 MAR 1998 08:37:32PM Ed Arend wrote:
Is it possible to specify the sorting and display ranges for the detail section of an AREV multi-table window?
Is there a good source of documentation for what these multi-table windows can and can not do?
Thanks in advance
Ed
At 01 APR 1998 05:24PM Michael Slack wrote:
I'm not quite clear on what you are asking. If you are asking how to get a selection of rows displayed to a window then you might want to check out CTRL-F10 (from inside a window) or the "\" (backslash) on the individual prompts.
For Arev 3.12, check out the "User's Guide: chapter 14. You might find page 215 (and following pages) interesting under the heading of "Using Indexes" for queries from inside a window.
Maybe something off of the subject but from TCL you can enter the command DOCWINDOW to get a report on a window and all of its background information for each prompt. This is something I've used only a few times but it's very handy.
Michael Slack
At 02 APR 1998 11:54AM Aaron Kaplan wrote:
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 Contact 15 L S
PartNo F 4 PartNo 10 R S
Qty F 5 Qty 10 L S
<Yes] 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
<Yes] to creating Data Portion Now?
At TCL type PAINT INV_ORD_WIN2. Use <EXISTING] 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 table1 = Column(s) in table 2
ORDNO ORDNO
Direction One-to-Many
F9 to save, then <esc] 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. <Yes] 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 DataType 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
<Yes] 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
<Yes] to Create Data Portion Now?
At TCL type PAINT ORDER_WINDOW. Use <EXISTING] 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 = Column(s) in table 2
CUSTNO CUSTNO
Direction One-to-One
F9 to save, then <esc] 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.
This is pretty old doc, and I've posted it verbatim. Obviously, the bug, if still there, will not be resolved
apk@sprezzatura.com
At 02 APR 1998 03:17PM Ed Arend wrote:
Perhaps I was not clear before as to what I want to do.
I have created my tables. I have created the window and everything works. What I really need to be able to do is specifiy a date range for the detail table so the user can see only selected entries in the detail table.
Specifically… the master is an employees list. The detail is a list of transactions that are the times the employee scans in or out of the system at a bar code station.
My screen needs to show the transactions for a specific date or date range only and also only for the selected employee master record.
My question is does the multi-table window treat both tables as if they are one?
If this is true then I expect I can just write my select statement in a standard fashion. It seems to me that the select statement somehow has to specify the fact that the 2 tables are linked together and how they are joined before it can be used to load the window with the correct data. I have no examples of how one would create a select statement with a join. Maybe I am just not seeing it. I can build a query that does this but how does it link to the window? Do I just treat a query as if it were a select and the window will then have the correct information?