I have a table <companies> whose records are related, many to one, to another table <company types>. Users choose a value (such as "manufacturer", "financial", "educational", etc.) from a value list generated from the <company types> table using a radio button set.
I have a layout for companies (manufacturers). Is there a way that this layout always constrains the set of companies to ones designated as "manufacturers", even if there is a command for "show all records"?
Many thanks for any insights!