Hello,
I'm a bit confused here being newbie where I have a "Sites" table in which there is a field called "Site_Name" . In the table I do a lookup using field rules so the site names are in a drop-down list or popup in all my forms that reference the various site names. In another table I have a field called "Item_SiteName" to select the proper site name which is appropriate for that item.
I assume it is because the field record is now stored in a different table, but if I go to the top table in sets which is the Site table and change the spelling in the "Site_Name" field (My Sites Form), it does not cascade to the next table that I just saved the record in the above description. If I click on the field in my (Item form) that references the saved record "Item_SiteName" (It is displaying old spelling), the correctly spelled name is there in the drop-down list and it updates once selected saved, but there must be a better way of doing this. I want any top level changes in top table to cascade down to all the children that reference it without going to every record and doing the drop-down to update each record.
So, I have a table called "Sites" with each Site Name location and the unique ID number field called "Site_ID" and the other table item with a field for linking called "Item_SiteID" with a one to many relationship and referential integrity set to cascade changes. (Note:I have many table that use the site name drop-down list in their forms) Also each table has a field that matches "Site_Name" and "Item_SiteName". I do not link on these as I get an error message and forms do not open.
Any help is appreciated as usual I am lost here.
Thank you!
I'm a bit confused here being newbie where I have a "Sites" table in which there is a field called "Site_Name" . In the table I do a lookup using field rules so the site names are in a drop-down list or popup in all my forms that reference the various site names. In another table I have a field called "Item_SiteName" to select the proper site name which is appropriate for that item.
I assume it is because the field record is now stored in a different table, but if I go to the top table in sets which is the Site table and change the spelling in the "Site_Name" field (My Sites Form), it does not cascade to the next table that I just saved the record in the above description. If I click on the field in my (Item form) that references the saved record "Item_SiteName" (It is displaying old spelling), the correctly spelled name is there in the drop-down list and it updates once selected saved, but there must be a better way of doing this. I want any top level changes in top table to cascade down to all the children that reference it without going to every record and doing the drop-down to update each record.
So, I have a table called "Sites" with each Site Name location and the unique ID number field called "Site_ID" and the other table item with a field for linking called "Item_SiteID" with a one to many relationship and referential integrity set to cascade changes. (Note:I have many table that use the site name drop-down list in their forms) Also each table has a field that matches "Site_Name" and "Item_SiteName". I do not link on these as I get an error message and forms do not open.
Any help is appreciated as usual I am lost here.
Thank you!
Comment