HI. I created a form for some Master Items and some forms are Number fields. Of course they are editable in my Master Item form but when I call these items in to another form or grid, they are not editable. They need to be.
Surely there must be a way to do this?
Thank You
@HarryC are you showing these values as connected values? Those are not editable.
Important to note that you can only edit if the form is for the specific table that field is in.
For example, if you have a Customers table and Jobs table. Assuming each Job connected to a customer. You can’t edit a customer value from the job form, but you can still display the customer values in the jobs form.
I hope that makes sense.
Feel free to paste in some screenshots or additonal context if this doesn’t help so we can help get to the bottom of it.
I have a Master Item list that has fields such as Item Description and Item Price. These are master Items with values. But each Job System that I create (for a job) includes one or many of these Master Items… but I need to be able to edit the Price if needed, per job. For instance, Job 1 may use Master Item 1 with a Price of $2 but Job 2 may use the Same master Item but I may want to change the item price to $1.
Please tell me that there is a way to do this.
I see.
I don’t believe that would be ideal way to build the database. I think you’re better off having another Price field in the Jobs table and when you select the Master record have a record rule that updates the Price in the Job table to the value from the Master List item. After that you can tweak the price on a per job level.
The other option would be to create something like a Junction Table. Which means you’ll have table structure like this:
Master List
Jobs
Master List Job Items (connection to Master List and Connection to Jobs)
Then when working within a job you’d be adding a New “Master List Job Items” record by choosing the job and master list. You can then tweak the pricing in that record instead of the master list.
If this isn’t clear I’d be happy to make you a quick video explaining this concept.
Oh wow yes a video would be awesome thank you
Does anyone here have experience with these Junction tables?