Show Lookup detail fields in form only

0 votes

Is it possible to have lookup details only appear in the form field/lookup dropdown, and not in the table view? For example, I have an Order Number column that shows Customer Name in the form dropdown. However I don't want the customer name to show in the table, only order number

in How To by (2.3k points)

1 Answer

0 votes
Best answer

If you need multiple display formats for a field then you need to create and attach a view to the table. See: Table Views.

So in your case you can use the existing lookup format in the Form but then add an additional View Only format and use that exclusively in the Table Grid.

by (64.3k points)
selected by
Just tried this, but the field in question (order number) is the key that is joining the view. So it's not appearing in the list of available table fields. Edit: looks like I can trick dbFront by adding the field again in the view and casting it as nvarchar, so it no longer flags it as a duplicate field. But still wondering if there's an easier way.
You are correct, if it is a key field then you would need to duplicate it as a formatted field.
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
Powered by Question2Answer