Unique Record Dispaly

nileshr18nileshr18 Member Posts: 27
Hi,

In Tax Entry table there are reocrd with same document no's, I want to dispaly only the unique document no on the form when i apply filter on the posting date that falls between the range of posting date supposing that there are document no having same number?

Is there any solution for this....

Comments

  • rajpatelbcarajpatelbca Member Posts: 178
    i am not able to understand. can you give more information about it?
    Experience Makes Man Perfect....
    Rajesh Patel
  • David_SingletonDavid_Singleton Member Posts: 5,479
    nileshr18 wrote:
    Hi,

    In Tax Entry table there are reocrd with same document no's, I want to dispaly only the unique document no on the form when i apply filter on the posting date that falls between the range of posting date supposing that there are document no having same number?

    Is there any solution for this....


    Basically you create a function that scans the records, and inserts them into a temporary table, making sure only to insert unique records, then display the generated Temp table in your form.
    David Singleton
Sign In or Register to comment.