Very basic question (I think), so sorry in advance.
Let’s say I have a record of a product having NAME, LENGTH, and AMOUNT. There are thousands of these records.
Each record appears first on Table A but gets copied to Table B. How may I make it so a record’s LENGTH on Table A gets edited likewise on Table B?
I’m certain it’s a connection field solution, but the best I can do with connection fields is make a dropdown list when creating records on the child table with options from the parent. When I go to input a length, it offers me all the previous values of length from the parent table.
(Maybe the record should be the same record, not a duplicate at all, and simply appear on the other table? I’m not sure I know what I’m talking about).
Really depends on the work flow. ie what is the purpose of table B?
It sounds like table A contains your master list of unique products, name, length and amount, and table B is used to perform a task whereby user can select a product from table A and provides new inputs to fields contained in table B.
In this case, you would add a connection field to table B referencing ProductName or Product_ID field in table A. This connection would then automatically reflect any product changes you make in table A to all related records in table B.
I thought it was, yes, but I wasn’t ultimately able to utilize “add a connection field to table B referencing ProductName or Product_ID field in table A” so that “This connection would then automatically reflect any product changes you make in table A to all related records in table B.”
The job I’m trying to do is create a table (A) of Manufacturers with data pertaining to each such that when shared data fields are changed for a manufacturer on Table B, those changes are consistently applied also to the original Manufacturers table A.
Sorry to annoy. I went back and changed the solved status so I’d be able to return later.