I am reusing fields from different tables. The same why you do in programmering with super classes.
I cant figure out how you can be able to edit and change info of a lookup field in one table that belonging to another table. When i try to edit i get “Values in this column are calculated by a formula and can’t be manually changed” .
Are you able to be able to import fields from other tables and add or edit texts in those?
when you use a lookup it makes the column into a formula column. the formula does the lookup and returns the link to the other table.
formula columns cannot be edited. so you need to edit the other table in order to change the values in it.
you may need to provide a convenient way to allow users to do this.
one way is to add a buttom column that executes…
which, when clicked, will open an edit dialog for the row that your lookup column is linked to.
another way is to have a regular Text column that is editable (ie not a formula) and then use that text to do the lookup in another column. that way, the user can edit the text, and the lookup column will try to find the matching row in your lookup table.