Hi.
I want to put a olumn on a tablebox that is not an actual field in the table involved.
For example. I have a table with an Item No. On the tablebox I have the Item No. column as per normal, and I want to display the Item's description in the next column - but without adding an item description field to the underlying table and populating it from the item record when the item no changes.
Adding a 'textbox' column to the form is easy - but I'm sort of lost on getting the current row's item description to appear.
Can someone nudge me in the right direction here?
Many thnks.
0
Comments
Once you get a record from the database (think which trigger this is) you need to manually retrieve the item record from the database. You can then use that Item record, and its corresponding fields, in your columns.
My Blog - nav.education
Create a variable ItemName an and TItem record Variable.
In OnAfterGetCurrRecord trigger,
TItem.reset;
If TItem.get(Itemno) then
ItemName:=TItem.Description;
Bye
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog