Announcements
No record found.
Hello,
I want to know how to syn data in NAV. I have two tables, add and search, I want the information added to be viewed in the search table. Looking forward to your swift responses.
*This post is locked for comments
Can you please give more details with an example.
I created a menusuite candidate where it has 2 items which are add and search. when i click on the add candidate item, it allows me to fill in information and save but those information can only be viewed under the add candidate use case. what i want to achieve is, to link the two tables so that what ever information is added will be synced on the search table. for example if i open the search candidate item and clicked on next, it gives me what i added on the add candidate item.
Why do you need two different tables? From what I understood you could accomplish the same thing with one table.
Could you ellaborate the requirement a bit more please?
As others mentioned why you need two tables with same information, why can't you use one table ?
Anyhow to sync data between two tables you need add code in the add table on the validation of the fields or on modify trigger to go back and check search table and update it accordingly.
Thanks for your responses it helps. am working with only one table as you suggested and am able to achieve that task though i have an issue of making every information added to one candidate to be specifically for that candidate. i have added code and i set it to update only the candidate number that has been modified. but when i do this the information i added appears in order candidates as well. Am working on a recruitment system so is a candidate is added the status is set to Application successful, but when i click edit to shortlist a table is executed and what ever i added on that table displays for the next candidate too when i select to shortlist. in order words the info i added is not unique to the affected candidate..
It seems like primary key is not set correctly.
Can you please let us know the relation between those tables.
the primary key is set. They have Candidate No. in relation
You mentioned about Save button.
generally in NAV data will be stored automatically and no need of save button.
Please check whether there is any code behind that which is by mistake modifying all records instead of one
No i don't have a save button.
so, you open the page and do modifications and close the page.
those modifications are updated in all records?
then please check onmodify trigger of the respective table and page triggers.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
