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:
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