I have two tables: Publication and Quality Check.
The Publication table has two columns: Pub name (Primary) and Pub Type.
The Quality Check table looks up to the publication table.
Is it possible to set the publication type in the Quality Check table, based on how it is set on the related record in the Publication table?