Not saving multiple data tables (OpenInsight Specific) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Not saving multiple data tables (OpenInsight Specific) ====
=== At 06 DEC 2000 12:43:28PM Tom Savell wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
I have created a form with two EditTable controls.  Each EditTable is data-bound by a separate OI data table but with a common key.  When I created the form I used the ?Build Form Selection Criteria? to establish the common association of the key between the two data tables.  When I test the form the data is properly being read and loaded into the EditTables from each of the two data files.  However if I modify the data and save only one of the data tables is being updated.



I do notice that in the ?Build Form Selection Criteria? setup screen I can only establish the common key associated with one of the two data tables and in fact it is this selected data file that does properly execute a save.  If I select the other data table in the ?Ordinal Component List? the ?Selection Criteria? controls are all blank and are protected so I can not establish a key association with this second data table.  All four check boxes are checked in the ?Build From Selection Criteria? screen.



What am I doing wrong with my form?  What do I have to do to save the data from both EditTables to each of their respective data tables?



Thanks for your help.



Tom Savell
</QUOTE>
----

=== At 12 DEC 2000 05:27PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:  ===

<QUOTE>What fields are defined as the joins?  There are some issues with having the joined field as an edittable column.



Can you elaborate on your setup some more?







[url=http://www.sprezzatura.com" ]The Sprezzatura Group[/url]

[i]World Leaders in all things RevSoft[/i]

[img]http://www.sprezzatura.com/zz.gif[/img]





</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=8A883ADCBBE52A57852569AD00615D10|View this thread on the  forum...]]