Issue updating data

[ryanmce92]

Sorry for the vague title, this is kind of hard to explain so please bear with me.



I have created a supplier database with editing and adding forms to tables within the database. I have a supplier table, a product table and a supplier/product table.

The users have a form called edit a supplier, when they e.g edit the name of a supplier, it does not update the records already entered the supplier/product table.

I would like it that when the data is edited in the Supplier table it will update the data in the supplier/product table and any other tables & forms associated with the supplier name.

Any help with this would be greatly appreciated, thank you.

[ItsMe]

You can bind a form to a table or updateable query in order to UPDATE records.

[pbaldy]

Normally you'd have an ID number in the supplier table, and only the ID would be stored in related tables. That way, when the name changes, it will flow through automatically.

[June7]

As Paul suggests, save the key ID value, not the actual descriptive value. If you save the descriptor, will have to run an UPDATE sql action to modify existing records, which would look like:

UPDATE SupplierProducts SET Supplier="new name" WHERE Supplier="old name";

Or maybe set the descriptive text field in Suppliers as the key and set relationship linking to SuppliersProducts in Relationship builder to Cascade Update. I have never used Cascade Update. Actually, seldom set relationships. I manage data integrity with design and code.

[ryanmce92]

Hi All,

June I tried the relationship builder and used the cascade update feature and its worked a treat, thank you all so much!!