Hello,

I have a DB with multiple tables which all have specific information, but the one "constant" is the customers. Here is my problem...

I create my customer in the customer layout (customer table), then go to a systems layout (system table, related to customer via customer ID) and create a new system. All is good so far...however, if i change the name of the customer back on the customer layout the name of the customer in the system layout does not update. I know that it is the same customer, because i can just change the NAME field to use the name from the customer table (rather than the name field form the related table) while leaving the ID field alone and all looks good.

So...Im not sure ware to look for the problem/solution here. Any pointers in the right direction would be much appreciated.

thanks

You might be better of posting your file on the forum. Don't forget to ZIP it first.

thanks for the reply. (this is modifications to someone elses work so just trying to understand the issues before i make changes) Puting the customer name from the customer table on the layout via the relationship does make the most sense. Thanks for providing insight on this one. I really wanted to just be sure i wasnt missing something obvious!

Thanks again! things always make more sense once its been looked at from a different point of view.