| Hide Blanks in a List Item - Tricky Situation! [message #379533] |
Tue, 06 January 2009 23:42  |
amit_yadav
Messages: 11
Registered: January 2009
Location: India
|
Junior Member |
|
|
Dear All,
Let me explain the set up first...
We have a Data Block A based on a join between two tables. In this data block we have a list item Note Type A and a text item Note Text A, both belongs to the secondary table of the join. This data block is the query data block of the form.
We have another Data Block B which is not the query data block but is in relation (as a child) with the Data Block A. Data Block B also has a list item Note Type B and a text item Note Text B, and these fields too refer to the same columns and table as the ones in Data Block A.
This arrangement is in place because business requires enabling query on only those note types which are listed in Note Type A. But once the records are fetched one should be able to see the data for Note Type B and Note Text B as well.
Now the problem is... when doing a query all for the Data Block A, those records which does not have any note type as listed in Note Type A but have note types as listed in Note Type B will not get listed. This is not desirable, so to fetch all records I have included the list item values of Note Type B in Note Type A and for these values list elements are kept blank. Because of these blank elements we now see a blank space in the list box which might cause a disagreement over the solution.
My question, is there a way we can avoid this blank space to be shown on the list box while keeping other things as they are, OR is there a different solution altogether to handle this whole requirement? Please suggest, and let me know if more details are required.
Thanks,
Amit
[Updated on: Tue, 06 January 2009 23:56] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
