The Missing Man Posted January 5, 2015 Posted January 5, 2015 I created a portal that is based on a company table related to a Estimate_Line Item table. To this I have two related fields: parent client key = ::child client key and check box options= vendor (which is a calculation field="vendor) It currently tells me when I click in the portal on my company table that this action cannot be performed because this field is not modifiable. The portal is based on the Estimate_Line Item table and all fields located in it are from that table as well. Any help appreciated.
The Missing Man Posted January 5, 2015 Author Posted January 5, 2015 Ok I can modify the portal info now but I cannot add a new line item into this portal, it has locked me out. I know I need to click something I just cannot find it.
LaRetta Posted January 5, 2015 Posted January 5, 2015 Go to your relationship graph and open the link between the two table occurrences. Below on the Estimates side, check 'Allow Creation of Related'. :-)
The Missing Man Posted January 5, 2015 Author Posted January 5, 2015 With this clicked I get this action cannot be performed because this field is not modifiable. With it not clicked I cannot add anything. In both situations I can go into existing records and modify them to my hearts content. Any thoughts? OK, I think I have it working. I eliminated one of my criteria in the relationship and it appears to have everything working now.
Ocean West Posted January 5, 2015 Posted January 5, 2015 you have a multi predicate key remove "VENDOR" check box from the relationship and use some other means to set that. (scripts)
LaRetta Posted January 5, 2015 Posted January 5, 2015 Ah yes, Stephen ... I misinterpreted this part: I have two related fields: parent client key = ::child client key and check box options= vendor (which is a calculation field="vendor) And since the Company table could not write 'Vendor' through to the Estimates field (because it was a calculation and therefore not modifiable) the action could not proceed. Nice catch! So yes, removing the checkbox line would do the trick!
Recommended Posts
This topic is 3946 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now