@Normal@<+!><:f720,BHelvetica,0,0,0><:f900,6Times New Roman,0,0,0><:f900,6Times New Roman,0,0,0><+!><:f720,BHelvetica,0,0,0>Approach Tech Notes
@Normal@<:R1,6,1,2160,1,4320,1,6390,1,7110,1,7470,1,7920,><+!><:f240,6Times New Roman,0,0,0><-!><+!>Approach 2.0 for Windows<:f160,6Times New Roman,0,0,0> <:f160,BHelveticaNeue MediumCond,0,0,0>TN 3/93-1001<:f320,BHelveticaNeue MediumCond,0,0,0>
@Normal@<:R><+!><:f280,BHelvetica,0,0,0>Trouble Shooting Problems with Repeating Panels<-!><:f320,BHelvetica,0,0,0><:f>
@Normal@<+!><:f720,BHelvetica,0,0,0>
>
[lay]
Standard
513
[rght]
15840
12240
1
1440
1440
1
1440
1440
0
1
0
1
0
2
1
1440
10800
12
1
720
1
1440
1
2160
1
2880
1
3600
1
4320
1
5040
1
5760
1
6480
1
7200
1
7920
1
8640
[hrght]
[lyfrm]
1
11200
0
0
12240
1440
0
1
3
1 0 0 0 0 0 0
0
0
1
[frmlay]
1440
12240
1
1440
72
1
792
1440
0
1
0
1
1
0
1
1440
10800
2
2
4680
3
9360
[txt]
>
[frght]
[lyfrm]
1
13248
0
14400
12240
15840
0
1
3
1 0 0 0 0 0 0
0
0
2
[frmlay]
15840
12240
1
1440
792
1
14472
1440
0
1
0
1
1
0
1
1440
10800
2
2
4680
3
9360
[txt]
>
[elay]
[lay]
1
519
[rght]
15840
12240
1
1800
1440
1
1440
1800
1
1
2
1
0
1
2
1800
6000
11
1
720
1
1440
1
2160
1
2880
1
3600
1
4320
1
5040
1
5760
1
6480
1
7200
1
7920
6240
10440
0
[hrght]
[lyfrm]
1
11200
0
0
12240
1440
0
1
3
1 0 0 0 0 0 0
0
0
4
[frmlay]
1440
12240
1
1800
72
1
792
1800
0
1
0
1
1
0
1
1800
10440
2
2
4680
3
9360
[txt]
>
[frght]
[lyfrm]
1
13248
0
14400
12240
15840
0
1
3
1 0 0 0 0 0 0
0
0
5
[frmlay]
15840
12240
1
1800
792
1
14400
1800
0
1
0
1
1
0
1
1800
10440
2
2
4680
3
9360
[txt]
@Normal@<:I270,0,0,0>for<+"><:f200,6Times New Roman,0,0,0> an additional example of correctly setting up an order form with a repeating panel, see the Orders.vew file that ships with the Approach template files (Approach\Tmplates\Largbiz\Orders.vew). In this example, the line
item database is the inventory database and inserted between the Order and the Product databases.<:f><-">
@list@<:#1988,4200>1. In Design mode click the border of the top row of the repeating panel, the row displaying the field
names, with the right mouse button. The entire repeating panel becomes outlined. Hold down either
mouse button and drag the repeating panel to the desired location.
@Normal@<:#284,4200>
@Normal@<:#284,4200>To resize the repeating panel:
@list@<:#284,4200>
@list@<:#2272,4200>1. In Design mode, click the border of the top row of the repeating panel, the row displaying the field
names, with the right mouse button. Sizing handles should appear in the middle on each side of the
top row. Use either mouse button to drag these sizing handles in the desired direction.
@Normal@<:I270,0,0,0><:#1724,4200><+"><:f200,6Times New Roman,0,0,0>Note: If you click in the body of the repeating panel, Approach will select the whole panel, and no
sizing handles will<:f> <:f200,6Times New Roman,0,0,0>appear. Make sure you click in or on the row that contains your field names, th<-"><+">e
top row, to activate the sizing handles. For more information see page 5-22 of the User's Guide.<-">
@list@<:#1136,4200>1. Resize the top row of the repeating panel vertically and/or horizontally so more fields may fit. (See
item F. above).
@list@<:#2272,4200>2. Use the field tool in the tool bar (6th button from the right) to insert a field in the top row. Once Field Style is displayed, select the proper database, highlight the desired field and click OK. The entire
field must be contained in the top row of the repeating panel, not touching any of the borders of the
panel.
@list@<:#960,4200><+"><:f200,6Times New Roman,0,0,0>Note: If Show Label is selected in Field Style then the field's box and the field's label must be
completely contained inside the top row of the repeating panel, not touching any borders.
@list@<:#5112,4200>1. In Design mode select the repeating panel with the right mouse button. You'll
notice that the status bar at the bottom of the screen will display Repeating Panel. Now drag the repeating panel with the right mouse button to a different part of the screen and release
the mouse button. Any field or object that doesn't auto-matically move with the repeating panel is not
yet considered part of the repeating panel. Therefore you need to resize the repeating panel to
include the fields or objects which were not moved with the panel, or just resize the field or object and
drag it back inside the first row of the repeating panel.
@list@<:#2272,4200>2. You may use the nudge keys or arrow keys on your keyboard to move the fields so they're not
touching any repeating panel borders. Once inside the repeating panel, use the test described in step 1 to
make sure that the field or object is considered part of the repeating panel.
@Normal@<:#852,4200>If the database from which you want to add fields to the repeating panel is not available in the Add Repeating Panel dialog, then try:
@list@<:#284,4200>
@list@<:#1136,4200>1. Check the Join Dialog box to make sure that this database is joined in this particular .vew file and
it is not the left-most database.
@list@<:#3976,4200>2. If the database you want to base the repeating panel on is the left-most database in the Join dialog,
the form is based on the wrong database. Repeating panels must come from joining databases rather
than the main, leftmost, database for that form. Create a new form where the main database is a
different database and the desired repeating panel database is joined to that main database. See page 3-45, step 7 of the User's Guide to create a form based on a specific database.
@Normal@<:#1136,4200>Cannot add any new lines or more than one line to a repeating panel. Or the same field entry appears
in each row of the repeating panel.
@Normal@<:#293,4200><+!><:f240,BHelvetica,0,0,0>
@Normal@<:#284,4200><+!><-!>Example
@Normal@<:I270,0,0,0><:#1704,4200>An order form displays the same product or price for each line of the repeating panel. The desired result is different products and associated prices displayed on each different row of the repeating panel.
@Normal@<:#1704,4200><+!><-!>You cannot add any new lines (records) or more than one line to a repeating panel, or the same value appears in each row of the repeating panel. For example, if you can only enter one product or product price per invoice try the following:
@list@<:#284,4200>
@list@<:#1136,4200>1. In Browse, click inside the last blank line in the repeating panel to add a new record to the
repeating panel. If this doesn't work try 2.
@list@<:#1988,4200>2. In Design mode, double click the repeating panel with the right mouse button, which should pop up
the Panel Options dialog box. Make sure the "Fields From Database" box correctly displays the
database the repeating panel should be based on.
@list@<:#2272,4200>3. It may be due to a design flaw. You need a line item database which holds the line items of the repeating panel. The example above compares a correct and incorrect method for creating an order form which uses a repeating panel to attach multiple line i
@list@<:#4260,4200><+!><-!>1. You have included the field from the line item database, the database the repeating panel is based
on, that joins the line item database to the main database in the repeating panel, and are trying to
change it. In this case, Approach warns you that changing this value may unjoin this particular line
item, or detail, record from the main database. Generally, you will not want to alter the field that joins the line item database to the main database in the repeating panel. If you must display that joined field in the repeating panel, consider designat
ing it as read only.
@Normal@<:#284,4200>
@list@<:#1988,4200>2. You have included a joined field from a different database in the repeating panel. Approach is
warning you that you are about to modify information in this joined field which may affect the relation of specific records in other joined databases.
@Normal@<:#284,4200><+!>
@list@<:#2272,4200><+!><-!> A repeating panel placed on a form in Order should be based on LineItem (see diagram of Correct example). Then each row of the repeating panel is a record in LineItem, and each record in LineItem is joined to one order based on the order number.
Many records in LineItem can be joined to one record in Order.
@Normal@<:#284,4200>
@list@<:#2556,4200> Each record in LineItem should be joined to one record in Product. This allows fields from Product to be placed in the repeating panel based on LineItem. Then, different rows in the repeating panel can display separate products. Since many records in Li
neItem can be joined to one record in Product, not only can different rows
@list@<:#284,4200>
@list@<:#1136,4200> in the repeating panel display different products for the same order, but also different orders can display the same product.
@list@<:#284,4200>
@list@ If the LineItem database is not present, see Incorrect example below, then the same Product is joined to each line of the repeating panel for a particular order. Thus, the same product is forced to appear on each line of the repeating panel for that order