show related field
For some reason I can't get this work.
I have 3 tables: Factory, Basic Garment and Technical sheet
In my Factory table I have two fields Factory::Country & Factory::Name which is the country of origin name of factory.
In basic garment I chose from a drop down list the name of the factory that is going to make this garment.
in Technical sheet, I from a drop down list, chooses my basic garment name, and automatically it shows the assigned factory, but how do I also have it to show that factory's place of origin...?