Form with multiple data sources

(1) Share

Report

Posted on by D365 beginner

618

Hi Experts,

I have a requirement that in a form I need to have two different data sources, for example Table A and Table B. In the form design I have two tabs for each table fields. There is a number sequence set for a field in the Table A. My problem here is when I enter the fields in the first tab (Table A) and when I click on the second tab the data which I entered in Table A is getting saved. I don't want to happen this, it should save the record only when I fill the details in both the tabs and press ok command. No idea why it is saving the record when I am switching the tabs. Any help please.

Thanks

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

nmaenpaa 101,160 Moderator on at

Like (1)

Report

RE: Form with multiple data sources

Records on forms are saved whenever you move to another record on the same or different data source. You can't prevent this. Only one record at a time can remain "unsaved".

If you need the user to complete a more complex data entry including multiple records and/or multiple tables, and save it only once the user is done, you should have temporary tables as your form data sources. When the user clicks OK, you would then save data to the actual tables.

Was this reply helpful? Yes No
D365 beginner 618 on at

Like (0)

Report

RE: Form with multiple data sources

Thanks Mr. Nikolaos for your valuable input. I have decided to go with temporary tables instead of actual data tables.

May I ask you one more thing, In the same above form, can I make mandatory fields in the form from both data sources ? Imagine I use two data sources in the form Table A (Header) and Table B (grid) having a relation between them which could be an employee number. I need the user to fill the header part and at least one record in the grid before closing the form. Can I make use of validatewrite() here ? If yes how ?

Thanks in advance.

Was this reply helpful? Yes No
KE-25091748-0 15 on at

Like (0)

Report

Form with multiple data sources

Hi, do you mind telling me how you were able to show a tab for each data source? I'm in the same position, would like to add data from table 2 to the main form from table 1, as editable text areas, option sets, etc. and not lookups, but no luck.

Thanks

Was this reply helpful? Yes No
Martin Dráb 236,353 Most Valuable Professional on at

Like (0)

Report

Form with multiple data sources

Your description is very brief, but you didn't mention anything about the topic of this thread (how to prevent saving when switching to a different data source), therefore your question doesn't seem to belong here.

Please create a new thread explain your particular scenario and problem there. Please include more details, because it isn't currently clear what you need.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Form with multiple data sources

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Form with multiple data sources

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates