Problems with multi-file database solution
I am currently trying to design a solution for keeping track of the ordering history of various articles.
I have a file for the orders, and one for each article type: antibodies (contains three main tables for each of three kinds of antibodies), chemicals, lab wares. I want people to be able to go through any of the databases and then click a button to order any article.
What I have done so far is to set up the following scripts, which are supposed to
- check for a matching record in the "orders" database
- create a matching record if none is found
- put the information about the order in a related table (through a portal)
The table that holds the information about the articles that can be ordered is called "Orders_data".
The table used for storing the single orders is called "OrdersDB_placedOrders".
I am using an intermittent table for moving the data between the "sender" (e.g. the antibodies database) and the "recipient" (the orders database), which is called "Order_FieldSetters_Global".
The scripts are meant to write data into this "Global" table; from there, the data is being sent to the necessary fields.
-> this is supposed to create a new record in the related table "OrdersDB_placedOrders"