# Multiple SHEETS with 1 LIST use IDE Clarion 11

**URL:** <https://clarionhub.com/t/multiple-sheets-with-1-list-use-ide-clarion-11/3704>\
**Category:** questions\
**Tags:** sheet, list, c11\
**Created:** [December 15, 2020, 1:28am UTC](https://clarionhub.com/t/multiple-sheets-with-1-list-use-ide-clarion-11/3704 "2020-12-15T01:28:57Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Anes](https://clarionhub.com/letter_avatar_proxy/v4/letter/a/3da27b/32.png) [@Anes](https://clarionhub.com/u/Anes)\
**Post date:** [December 15, 2020, 1:28am UTC](https://clarionhub.com/t/multiple-sheets-with-1-list-use-ide-clarion-11/3704/1 "2020-12-15T01:28:57Z")

</div>

Regards,  
I am a new IDE clarion 11. I get a problem, when I want to make browse with 3 SHEET. Each SHEET uses a different key. I made 1 list on 1 SHEET, then I copied it to 2 other SHEETS. When I look at the Embeditor source, in SHEET there are 3 Tabs with each list. The results are different from the example given by clarion 11. In the example program that I opened with the Embeditor, in SHEET there are 3 Tabs without a list, and the list is under SHEET.

Can anyone help me. How to do it with IDE clarion 11, so that the results match the example given, which is in SHEET there are 3 Tabs without a list, and the list is under SHEET.

Your help will be greatly appreciated.

Johanes

---

<div class="post-metadata">

**Author:** ![totalhip](https://clarionhub.com/user_avatar/clarionhub.com/totalhip/32/1477_2.png) [@totalhip](https://clarionhub.com/u/totalhip)\
**Post date:** [December 15, 2020, 1:42am UTC](https://clarionhub.com/t/multiple-sheets-with-1-list-use-ide-clarion-11/3704/2 "2020-12-15T01:42:50Z")

</div>

Actually, the list needs to be outside the sheet declaration. That way, it will appear on all 3 tabs.

If using the Browse template, changing keys used with the list can be defined on the Conditional tab settings for the Browse using something like:  
?Sheet{PROP:ChoiceFEQ} = ?Tab:Number

Hope that helps and gets you going.

Douglas

---

<div class="post-metadata">

**Author:** ![CarlBarnes](https://clarionhub.com/user_avatar/clarionhub.com/carlbarnes/32/1859_2.png) [@CarlBarnes](https://clarionhub.com/u/CarlBarnes)\
**Post date:** [December 15, 2020, 5:42pm UTC](https://clarionhub.com/t/multiple-sheets-with-1-list-use-ide-clarion-11/3704/3 "2020-12-15T17:42:02Z")

</div>

As noted you want a single LIST like below not on a TAB. Use the Tab Order tab, or edit in the Window… Editor.

```
Window WINDOW('Browse Vendors'),AT(,,627,376),FONT('Microsoft Sans Serif',8),DOUBLE,GRAY, |
          IMM,MDI,SYSTEM
          LIST,AT(4,23,431,184),USE(?Browse:1),HVSCROLL,FORMAT('162L(2)|M*~Vendor Name~' & |
            '@s39@144L(2)|M*~Sort Name~@s39@14C|M*~ST.~@s1@34R(4)|M*~Vend. No.~C(0)@n_6' & |
            '@32R(2)|M*~Auto. No.~C(0)@n_6@28R(2)|M*~Group~C(0)@n_6@56R(2)|M*~Purch. Fi' & |
            's. Yr.~C(0)@n-15.2@'),FROM(Queue:Browse:1),IMM,VCR,#FIELDS(GLO:VendorName,VENMST:SortName, |
            VENMST:Status,VENMST:VendorNo,VENMST:AutoNo,VENMST:GroupNo,VENMST:PurchasesCYr), |
            #ORIG(?List),#SEQ(1),#ORDINAL(1)

          SHEET,AT(1,4,619,241),USE(?CurrentTab),#ORIG(CurrentTab),#ORDINAL(43)
            TAB('&Name'),USE(?NameTab),#ORDINAL(44)
            END
            TAB('&Vendor Id.'),USE(?IdTab),#ORDINAL(46)
            END
            TAB('Vendor No.'),USE(?VendorNoTab),#ORIG(?Tab3),#ORDINAL(47)
            END
          END

```

If you want the same file in multiple browses in the same procedure you must setup alias files in the DCT.

---

<div class="post-metadata">

**Author:** ![JonW](https://clarionhub.com/user_avatar/clarionhub.com/jonw/32/1344_2.png) [@JonW](https://clarionhub.com/u/JonW)\
**Post date:** [December 16, 2020, 1:50pm UTC](https://clarionhub.com/t/multiple-sheets-with-1-list-use-ide-clarion-11/3704/4 "2020-12-16T13:50:35Z")

</div>

And the next step is that in the Actions for the list you go to “Conditional Behaviour” and for tabs beyond the first tab you put choice(?currentTab) =   
and put in the key to use for that tab

---

<div class="post-metadata">

**Author:** ![CarlBarnes](https://clarionhub.com/user_avatar/clarionhub.com/carlbarnes/32/1859_2.png) [@CarlBarnes](https://clarionhub.com/u/CarlBarnes)\
**Post date:** [December 16, 2020, 4:24pm UTC](https://clarionhub.com/t/multiple-sheets-with-1-list-use-ide-clarion-11/3704/5 "2020-12-16T16:24:50Z")

</div>

As noted by @totalhip TotalHip an alternative to Choice(?CurrentTab)=1,2,3… is ?CurrentTab{PROP:ChoiceFEQ} = ?Tab:Label. That way if the Tabs are reordered, or a new tab inserted, the code still works as before.

FWIW … a SHEET works like an OPTION where ?CurrentTab{PROP:Value} returns ‘Text Label’ of the selected TAB(‘Text &Label’). Note the & Amp is removed.

---

<div class="post-metadata">

**Author:** ![totalhip](https://clarionhub.com/user_avatar/clarionhub.com/totalhip/32/1477_2.png) [@totalhip](https://clarionhub.com/u/totalhip)\
**Post date:** [December 16, 2020, 5:50pm UTC](https://clarionhub.com/t/multiple-sheets-with-1-list-use-ide-clarion-11/3704/6 "2020-12-16T17:50:10Z")

</div>

Have been around too long. I had honestly forgotten the reason why using PROP:ChoiceFeq is preferred.  
Thanks for the wake-up reminder.