I have two tables that contain information. One is a Production Cost table and the other is a Utility Usage table. I do not want to change these tables, they are fixed in terms of their content. I would however like to reference these tables from layouts, preferable using their serial IDs.
Example: Product 1 = Cost Code 1, then the actual dollar cost referenced by CC1 is linked to Product 1
Does that make sense? I can put together a visual if needed?