Hello, Appsheet Friends!
I am currently try to build a simple Appsheet Inventory Management software. Here is the relationship chart:
Premise
I have 3 tables that connected each others, they are:
- item table = id (PK), brand, series, category, unit
- inventory_log table = log_id (PK), dateTime
- inventory_log_details = details_id (PK), inventory_log_id(REF to log_id), item_id(REF to Item), quantity, sn, purchaseDate, warrantyTime
I could successfully make forms uploaded, but they all missing the inventory_log_id (REF) on inventory_log_details result. It shows, but greyed out and warning sign.
Can someone give a solution? thanks
User | Count |
---|---|
15 | |
11 | |
10 | |
8 | |
3 |