Hello,
I would like to know if we can use the master/items view for a non-primary key field of the master table?
This is useful because I have ID fields in master table for other tables and I would like to see the details of the matching row of the other table when viewing the master table record.
Simple example for a trading firm which has a supplier invoice, a buyer invoice and the related shipment. Only ID fields illustrated below.
Table: supplier_invoice
id_supplier_invoice (primary key)
id_shipment (foreign key to shipment table)
Table: buyer_invoice
id_buyer_invoice (primary key)
Table: shipment
id_shipment (primary key)
id_buyer_invoice (foreign key to buyer_invoice table)
So under shipment table, I would like to be able to see all related records from both supplier_invoice and buyer_invoice as items view. However it only works for supplier invoice.
Please advise.
Thanks,
Vikash.
System info:
PHP Version: 7.3.14
mysql version: 5.5.64-MariaDB
Web server: Apache
Client: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0
I would like to know if we can use the master/items view for a non-primary key field of the master table?
This is useful because I have ID fields in master table for other tables and I would like to see the details of the matching row of the other table when viewing the master table record.
Simple example for a trading firm which has a supplier invoice, a buyer invoice and the related shipment. Only ID fields illustrated below.
Table: supplier_invoice
id_supplier_invoice (primary key)
id_shipment (foreign key to shipment table)
Table: buyer_invoice
id_buyer_invoice (primary key)
Table: shipment
id_shipment (primary key)
id_buyer_invoice (foreign key to buyer_invoice table)
So under shipment table, I would like to be able to see all related records from both supplier_invoice and buyer_invoice as items view. However it only works for supplier invoice.
Please advise.
Thanks,
Vikash.
System info:
PHP Version: 7.3.14
mysql version: 5.5.64-MariaDB
Web server: Apache
Client: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0