Can one modify the field names shown in current selections box?
Hello,
Is there any way one could modify the field names shown in 'Current Selections' box?
Example:
I have customer name in column db_cust. When a specific customer is selected, current selection box shows following:
db_cust - 'specific customer'
What I would like it to show is:
Customer - 'specific customer'
I understand that renaming the column in load script would solve this problem, but is there any other way one could manipulate the field names in current selections box.
For this reason and others, I consider it a good practice to in the script name all of your fields something that your users can understand. I wouldn't have a field named "db_cust", even if that's what it's called on the database. We're not doing this for ourselves as developers; we're doing it for our users. So I'd just name the field "Customer".
When the Data Model begins to get big and hairy, is there a recommended Best Practice for keeping field names friendly, yet organized?
For instance, I generally Qualify my tables, but the qualified name makes them less friendly. Is there any easier method for reverting the name back for the purposes of labelling?
Well, I'd recommend just not qualifying your tables in the first place. As for keeping names friendly, use names that make sense to your users. If your users call something the "Order Item", call it the "Order Item". Do not call it Order_Item, ORDITM, orders.order_line_no, or whatever else.
I'm not sure what you mean by organized. Like you still want them grouped in some way? Like here are all the order fields? You CAN pseudo-qualify fields by just naming them all similarly. "Order Item", "Order Quantity", "Order Customer" and so forth. But I typically wouldn't do this. "Order Quantity" might make sense, but "Order Customer?" I doubt your users refer to customers as "Order Customers", so following the general advice of using the terms your users use, you wouldn't want to do this.
I DO often organize fields on screen, though. In the example above, I might have an "Order Item" multibox with all the order item fields, a "Customer" list box with all the customer fields, and so on.
Also, you don't always need the NAME to tell you what field a table is in. Many properties boxes let you look only at fields on a specific table. So if you're trying to add dimensions to a chart, and you have 300 dimensions, but you know the dimension you want is on the "Order Item" table, then select that table to narrow down the list of fields.
I guess I'm kind of unclear what you're asking, honestly.
