lundi 30 mars 2015

Excel: Create a Collapsible Master-Detail View From Another Sheet?

I'm designing an excel template for importing data (into another DBMS).


The problem is, the data will be separated (normalized) into several tables in my DBMS (master-detail model).


Let's say I have two sheet Order and Order Detail.


The Order contains: ORDERID, CUSTOMERID, EMPLOYEEID, ORDERDATE, REQUIRED_DATE, and SHIPPED_DATE.


While Order Detail contains: ORDERID, PRODUCTID, and QUANTITY


I'm planning to create a template like this:


enter image description here


When the Order is entered, there will be a collapsible pane to enter the Order Detail (from corresponded Order).


Is it possible to create something like this? How to achieve that?


Thanks in advance :)


Aucun commentaire:

Enregistrer un commentaire