Set Field (Material Milestone::id_Milestone)
Their is a missing value or formula here
But thats probably not going to solve your problem and in order to solve your problem we need to knwo the relationship between materials and milestones..
if the relationship between materials and milestones is one material can have many milestones then Set Field (Material Milestone::fk_material_id ; $id ) might do the trick. If that is not the relationship between materials and milestones then the script has to do something different and we need to know the details.
Thank you for the reply,
Yes, one material has many milestones. Can you please specify about this "Set Field (Material Milestone::fk_material_id ; $id )" I dont know what Im going to do.
Can you please specify about this "Set Field (Material Milestone::fk_material_id ; $id )" I dont know what Im going to do.
You simply forgot to set the second parameter for the Set Field script step. That's what coherentkris is telling you. Set Field has two parameters:
1. What field do you want to set?
2. What data do you want in the field.
In the script you posted in the original post, the Set Field only has the first parameter. You've already defined the data you want for the second parameter. Simply add the variable $id as the Calculated result (see attached)
Thank you. I got it. But still not solving my problem.
unless I will add a new record..then my related record will show on my portal.
Sorry thong127, I guess I don't quite understand what's failing. Can you post a screenshot? Or better yet, a copy of the file?
1 of 1 people found this helpful
I suspect you have the relationship itself wrong. The logic is that every record in every table should have its own automatically assigned unique ID (either a serial or UUID); I assume this is the function of Materials ID in the Materials table and id_Milestone in the Milestones table (there is a naming issue there, but that's another matter). OK so far. BUT:
you appear to be using these two fields as the basis of your relationship—this is wrong. What you need in the Milestones table is a foreign key MaterialsID field, and the link between the two tables to be:
Materials::Materials ID = Milestones::Materials ID
If you do this, then each milestone record will have its own unique ID, and also have a non-exclusive Materials ID which will show which Materials record it belongs to.
I already have existing records on my Materials Table and I added the Milestone Table in order for me to track in which materials was used in.
Ok, but can you post a screenshot or a copy of the file?
A copy of the file would be best as would could test the primary key=foreign key as keywords mentions.
You can make a clone of the file without records by going to File/Save a Copy As.../Type: clone (no records)
Its working now. Thank you so much.
Thanks Keywords, Its working Now. That's solved the problem.