I want to add a field in a table that shows the value from another table on all records. E.g. Table A has Environment|Status field with many records. Table B has Status field with 1 record with a drop down for "Active" or "Inactive". If I change table B value to Active, I want all records in table A to show "Active" in status field. Are there any ideas?