Reference Table shows Warning Signs

Hello, Appsheet Friends!

I am currently try to build a simple Appsheet Inventory Management software. Here is the relationship chart:

sundeeseeyou_0-1718353478422.png

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.

sundeeseeyou_1-1718353885210.png

Can someone give a solution? thanks




1 3 145
3 REPLIES 3
Top Labels in this Space