AnsweredAssumed Answered

Data Entry in Layout

Question asked by WilliamLivingston on Jan 3, 2014
Latest reply on Jan 6, 2014 by philmodjunk

Title

Data Entry in Layout

Post

     I have created several tables of static data (product, client, analyst etc) and then have them related to another table (Sales Coverage) via a field in each called ID (which is just a serial id for records).  

     sample:  https://www.evernote.com/shard/s192/sh/481e5a44-08ac-4fb5-96b2-d45d6a42a2e1/19c4988f37b7b283c367df4bf3c5bf57

     Sample relationship - https://www.evernote.com/shard/s192/sh/e4544f98-d9b4-4918-8a4c-37d732cea3f1/6e065bdb0fab828caab2238d86344a6d

     I then created a layout that pulls various elements from the tables to display the actual values/attributes.  I would like to be able to use the layout for data entry/updates, but as it is set up now, if I change a data point in the layout (for example, change the frequency) it updates all records in that field and overwrites the static table "Frequency".  

     How would i configure this set-up so the layout will only update the "Sales Coverage" table and not the static tables that are related to it.  

     Any help would be appreciated (i am very new to this, so please excuse if this is a very basic question) Thank you

Outcomes