How to add look up on a form

(0) Share

Report

Posted on by D365 beginner

578

Hi Guys,

I have situation that I need to add a lookup on a form to select the data from the drop down list. Consider below example I have a table called Table1 with one field A and with data A1, A2, A3 etc and there is form called Form1 available for the same. (to allow user to create data on the table)

when I select the field account on a form the data from Table1 should be displayed as a drop down list and I should be able to select the either A1, A2 or A3 etc. sometimes user needs to write manually on the field which may not available in the list. (system should allow that too).

how can I achieve it. please help..

3173.Capture.PNG

*This post is locked for comments

All responses (2)

Answers (0)

D365 beginner 578 on at

Like (0)

Report

RE: How to add look up on a form

Thanks Crispin & Tatiana,

Can you guys give me a sample code for lookup method based on above example please ? Explaining where the code should be too... (datasource of the form or table etc)
Community Member on at

Like (0)

Report

RE: How to add look up on a form

Hi,

You can add the relation in your main table with your table A, using the key field.

With this you will display the list of your second table A and the fields that was setup in the table properties.

Or you can overwrite the lookup method in the field in your DataSource (in the form) to display the list that you want to show.