I am fairly new to LibreOffice in general and Base in particular and need some help with my form. Here is some background.
I have created a database with multiple tables including a Company table, a Product table, a ProductCategory table and a Media Contact table. The Company table has a 1:n relationship with the Product table (one Company can have many products) and 1:n with the MediaContact table (a Company can have many Media Contacts). The ProductCategory table has a 1:n relationship with the Product table (A Product Category can be associated with many products but a product can have only one category).
I have created a form for the Company table and have included a subform (table grid format) to show the many products associated with that company. In the subform, the ProductCategory is displayed as the FK reference to the ProductCategory PK.
I know that on the main form, if I have a FK showing in a data element, I can add a control to show the name associated with the FK (i.e. show (name) John Smith instead of (NameID) “5”). I would like to be able to do that same thing in the subform so the Product subform shows Product Category (Camera) instead of ProductCategoryID (3).
I would like to do the same thing with the Media Contact that is a FK on the Product table.
Can that be done?
Thanks for your help.
Regards,
David