Dropdown on page with the New tag to add to source table

Business Central/NAV User Forum
1

Hello,

I am looking for information on how to get my source table dropdown to let a user add a new record to the table.

Thanks.

2

Are you talking about a lookup to another table?

What does “my source table dropdown to let a user add a new record to the table” mean?

If you need a lookup to another table to get the value then look at table relations.
http://msdn.microsoft.com/en-us/library/dd355207.aspx

3

Already have source table working,

In RTC of Nav 2009, when you click into a field with a table relation in most cases if you have permissions there is a NEW option at the bottom, so that the user can on the fly add a new value to the table.

That is the option I need.

4

That is not related to permission…its related to table relation property in the field…

5

That is not related to permission…its related to table relation property in the field…

6

Actually it has nothing to do with either. The page that appears when you would click the New button, for example the Item Card when adding an Item, has to have InsertPermission allowed.

7

Matt put me on the path.

Needed to make a lookup page, with insert permissions.

Then needed to go to the source table and set the lookup form id to that page id.

Now I have a dropdown with New and Advanced.