PlaceWorks

Hi all, thanks for the suggestions. I had to delete the field and change the table design to autonumber. Thanks.

I'm trying to create a trigger so that when the field CCTAproject_id in my parent table "tbl_projects" is updated, rows will be created in all of my related tables and given the same CCTAproject_id. I only want this to happen once (due to the way I set up the new submission form, it generates a random string and then the client will update this field once to assign it a new ID number). However, whenever I update any field in that same record in the parent table, it creates another record in the related tables. Ex, I update different fields for one record three different times and three blank cells with that same ID are generated. I thought of creating a workflow that If the CCTAproject_id doesn't exist, then add the new record. When I tried dragging in the If/Then operator, it did not give me any fields or tables as options to select from. Is there another workaround to add the record only once to my related tables? My update forms are split between many related tables, which are all linked through CCTAproject_id. When a new project is added, that records only gets added to the parent table, not the related tables, thus the need for this trigger.

I'm trying to create a trigger that will add fields to a bunch of related tables based on the new CCTAproject_id that is entered on the parent table. It won't let me get rid of the ID field for some reason so I'm guessing that is a necessary field. My solution was to take the max existing value in the ID field and add a 1, so that new records increase sequentially by 1. I get an error when using this method, "Column '#inserted.CCTAproject_id' is invalid in the select list because it is not contained in either an aggregate function of the GROUP BY clause, (error code: SQL8120). But if I remove the number block containing the "MAX etc" and just leave it to equal a static number, the trigger works. I don't understand what the error means by grouping since the ID field is an integer and I'm not trying to group different field. Is there a way to manipulate the trigger so the numbers can increased based on existing values?