tab visibility: fields to select belongs to another table
hi [@mark](/u/mark), i want to set-up “visibility conditions” on various tabs based upon a [source] tab’.

this [source] tab has 7 columns (picture 1)

[[image]](https://aws1.discourse-cdn.com/business7/uploads/glideapps/original/2x/0/0895f6a7553e681974d8ba6497a30baa40c31bd2.png "image")

but in this [source] tab config (features > visibility), the fields in the selector are the ones of another tab (the [users] one), but not the one of…
tab visibility is currently only based on the user profile sheet. if you want to control tab visibility from a value in another sheet, you need to use relation/lookup, relation/rollup, or single value columns to bring in whatever value you need into the user profile sheet.

[https://docs.glideapps.c…](https://docs.glideapps.com/all/reference/design-and-structure/visibility-conditions#tab-visibility)
From the explore section you can see the resourcce which are linked with existing table(profile etc).

To see a resource which are not linked , you can select resource from the properties section of query activity

![1402857_pastedImage_0.png](/t5/image/serverpage/image-id/9513i93F570CE23A95886/image-size/large?v=v2&px=999 "1402857_pastedImage_0.png")




[View solution in original post](/t5/adobe-campaign-standard/query-with-custom-resources-in-acs/m-p/246365#M8688) you should be able to set the element to not be visible on page load, and then on the conditional tab of the element, you should be able to construct a condition where parent group’s thing’s creation date < parent group’s thing’s modified date, this element is visible. and when i say “should be able… I have figured out this issue and so for anyone else with the same issue.

In Designer for your XDP make sure you have a subform as the entry for the table row, and make this subform "Repeat Subform for Each Data Item" I found the subform could not be within another subform for this option to be visible.

So after this you can assign the row to the subform and the elements to the elements within the subform and hopefully it'll work.




[View solution in original post](/t5/adobe-experience-manager-forms/dynamic-rows-in-a-table-issue-also-relates-to-having-elements/m-p/204725#M6246) You could try using the in line view like this:


Select table1.col1, table1.col2, table1…., table2.col1, table2.col2, table2….  

 from  

(SELECT *  

FROM dbo.Shaft\_Scales  

WHERE dbo.Shaft\_Scales.ID = (SELECT max(ID) from dbo.Shaft\_Scales ID) as table1,  

(SELECT *  

FROM OtherTable  

WHERE dbo.OtherTable.ID = (SELECT max(ID) from dbo.OtherTable ID) as table2


—————- another approach from meandyou 


This works on [at least some] SQL processors


SELECT T1.* , T2.*  

FROM table1 T1, table2 T2  

WHERE …


Do we have to discuss why not to use “SELECT * ” in your SQL?<pre>


Try this


SELECT * FROM T1 as a, T2 as b WHERE a.ID = (SELECT max(ID) from T1)  

and b.ID = (SELECT max(ID) from T2);</pre> unfortunately that's not how it works. it's db mapping, and we're talking about joined-tables hierarchy. so the "other side" of the association must be in the referenced table (the detail one, not custom detail). you’re on the right track.

is the name column of the choices table of the same column type as the 1st place and 2nd place columns?

please post a screenshot of the error message and the complete expression to which it refers. Thanks for your reply, I feared it would not be trivail, as I coudnt find any scripts. Idealy the text from the databse is place in a table witht the last column beeing the barcodes path, the images are to replace the text path and be place inside the cell, fitting within the cells width and/or height. Hi Djhenry,
  

  
When you right-click a sheets tab, you can select all sheets. When you have done that, you can insert a row and enter all the information and all sheets wil contain that information.
  

  
Best regards,
  
Trowa hi patrick, - - the observed behavior can be considered an issue and i have logged it on our feedback portal, here: - fix. radlistview - dragging an item from one list view to another can result in incorrect scrolling of the source list view when it is not necessary. i have also updated your telerik points. we will do our best to include the fix of the issue in the r1 2019 release. a possible workaround is to use the custom drag-drop service below:  - - public partial class radform1 : telerik.wincontrols.ui.radform - { -     public radform1() -     { -         initializecomponent(); -         this.radlistview1.allowdragdrop = true; -         this.radlistview2.allowdragdrop = true; -   -         this.radlistview1.listviewelement.dragdropservice = new customlistviewdragdropservice(this.radlistview1.listviewelement); -         this.radlistview2.listviewelement.dragdropservice = new customlistviewdragdropservice(this.radlistview2.listviewelement); -     } - } -   - public class customlistviewdragdropservice : listviewdragdropservice - { -     public customlistviewdragdropservice(radlistviewelement owner) -         : base(owner) -     { } -   -     protected override void handlemousemove(point mousepos) -     { -         int? scroll = null; -         simplelistviewvisualitem item = this.droptarget as simplelistviewvisualitem; -         if (item != null && item.data.owner != this.owner) -         { -             scroll = this.owner.viewelement.vscrollbar.value; -             point clientpos = item.data.owner.viewelement.pointfromscreen(mousepos); -   -             if ((clientpos.y -                 (clientpos.x -             { -                 item.data.owner.viewelement.scroller.scrollbar.performsmalldecrement(1); -             } -             else if ((clientpos.y > item.data.owner.size.height && item.data.owner.viewelement.orientation == orientation.vertical) || -                 (clientpos.x > item.data.owner.size.width && item.data.owner.viewelement.orientation == orientation.horizontal)) -             { -                 item.data.owner.viewelement.scroller.scrollbar.performsmallincrement(1); -             } -         } -   -         base.handlemousemove(mousepos); -   -         if (scroll.hasvalue) -         { -             this.owner.viewelement.vscrollbar.value = (int)scroll; -         } -     } - } - - - i hope this helps. let me know if you need further assistance. - - regards, - hristo - progress telerik - get quickly onboarded and successful with your telerik and/or kendo ui products with the virtual classroom free technical training, available to all active customers. learn more. use the query string to pass the venue id to the generic venue display page, make your <a> tags ref that page with "?id=xxx" at the end, from the venue page fetch that xxx value and query your db for that specific venue, and display that venue's fields as you like.


$myvar = $\_GET['id']; and thus  

Select * FROM table WHERE field='$myvar'