Form - Getting records

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

Not Answered This post has 0 verified solutions | 6 Replies | 1 Follower

36 Posts
305 Points
Joined: 2011-6-8
Last Online:
2012-9-21 19:08
Location: Eslöv, Sweden
Håkan Westrup posted on 2012-9-4 17:04

Hi all!

I have a form with a Tablebox.

The form has the table 'Service Item' as Source table.
When i run the form, records are displayed in the tablebox. -So far so good.

But, for every record that is dispayed I want to get information from that record.
How can I get information from the record that is displayed in the tablebox?

I have tried in 'Form - OnNextRecord' but no success.

Can you please help me.

Regards,

Håkan W

 

All Replies

Male
2,347 Posts
34,155 Points
Joined: 2006-4-10
Last Online:
2013-6-18 15:34
Location: Pune India
Moderator
Amol replied on 2012-9-5 6:13

Which record you want to display on the form?

Is it information from Service Item table or from another table?

-Amol

http://dynamicsuser.net/blogs/amol

Don't forget to  the post(s) that solved your problem

4,028 Posts
88,360 Points
Joined: 2009-2-17
Last Online:
2013-6-18 17:35
Location: New Delhi
DynamicsNAVMVP
Moderator
Mohana replied on 2012-9-5 6:13

Write code in Form - OnAfterGetCurrRecord() trigger.

but what exactly is your requirement?

 

Male
6,791 Posts
158,487 Points
Joined: 1995-10-1
Last Online:
2013-6-18 23:15
Location: Middelfart, Denmark
DynamicsNAVMVP
SystemAdministrator
Erik P. Ernst replied on 2012-9-10 10:49

Hejsan Håkan,

Let me understand your problem correctly. You have a form using Service Item. Now you say that your records are being displayed in the form. But also that you want to display information from that record in the form. Normally I would just add those missing fields containing the information to the form.

Or did I miss some part of your question here?

Best regards,
Erik P. Ernst
Webmaster 

DUG’s Admin's Blog

Don't forget to "Verify Solution" the post(s) that solved your problem. This credits the experts who helped, earns you points and marks your thread as Resolved so we all know you have been helped.

36 Posts
305 Points
Joined: 2011-6-8
Last Online:
2012-9-21 19:08
Location: Eslöv, Sweden
Håkan Westrup replied on 2012-9-10 13:12

Hi!.

I am showing records from the table Service Item in a Form.
I am also are showing some information from Sales line,, Sales Head like sales order number, salesman and so on.

This was my original question.

The solution that I found  was to add onbound text boxes in the Table Box and put information there (from Sales line and Sales Head).
I do this action in Form - OnAfterGetRecord.         IT WORKS! :-)

But now I have a new question

Say that I only want to show information from Service Item för salesman #11.

Salesman #11 doesnt exist in the table Service Item.

How do I do to only display rows for that salesman?

.
 Regards,

Håkan W

4,028 Posts
88,360 Points
Joined: 2009-2-17
Last Online:
2013-6-18 17:35
Location: New Delhi
DynamicsNAVMVP
Moderator
Mohana replied on 2012-9-10 13:17

You should Identy any table relation between Service Items and Salesman and put filter on OnOpen form trigger..

36 Posts
305 Points
Joined: 2011-6-8
Last Online:
2012-9-21 19:08
Location: Eslöv, Sweden
Håkan Westrup replied on 2012-9-10 16:58

I have never done this.

Have you any details how to do this - Please

 

/Håkan

Page 1 of 1 (7 items) | Get this RSS feed | Bookmark and Share