Number sequence problem

Hello all AX users.

The thing is that i have two forms .

The number sequence is given to the records created and same number sequence i have shown in the look up field in the next form relating to all records.

The thing which i want is as number sequence is already alloted to the records in the first form and is shown in next form,but if a record for the number sequence is generated in the next form,then for the creation of next record that alloted number sequence should not be displayed again in that look up field.

How can i obtain this functionality ?


Still not clear of what you said. Pls tell the purpose and whole functionality you need…

Thanks and Regards,


Sorry Kevin for your inconviniency.

Actually to be short and sweet,if any number sequence hase been applied to any of the records from look up,next time when user creates record,that already allocated number sequence should not be displayed in the look up.

Hi lalit,

override the lookup method of the field in the second form.

In lookup method create a query with the first table as the parent and second as the child and make a notExists join between those tables.

for creating lookups, refer this

  • Arun

Thanks arun,your solution did really worked…