No, it wouldn't change, since you're only inserting a text into a field. The value list will change, but that isn't reflected in the field
Rather than insert a name into Design, you should use key fields in both tables – a primary key in the Maker table and a foreign key in the Design table.
Create a value list that has 1. field: Maker::primaryKey, 2. field: Maker::name, show second only.
Format the foreign key field in Design as a popover with the value list.
Select a name from the popover – and you're actually inserting a key that resolves (thanks to the popover) into the appropriate name from the value list. If you change the name of a Maker, it will also change in all Design records where its key it used.
Note that so far all this works without any relationships; but usually you will want to create a relationship based on
Design::foreignKeyMaker = Maker::primaryKey
so you can display other fields from Makers in a Design context, e.g. an address on a PO, and create statistics, e.g. how many Designs for a given Maker.
Thanks for your help answering my Question.
Reworked my Database and everything seems to be working.
Had to review the tutorials again to make sure I got everything in your reply.