Ref Column blank, despite added as a related record

Appsheet app runs on an AppSheet DB. It is a cash ledger/journal include different books, categories, user, etc.
main table: Ledger, it has reference of table Book, and Book has reference of table Stack. My primary navigation shows Stacks, then on clicking Stack it Shows related Books, then on clicking book, it shows Related Ledgers. Most flow is default configuration. Ledger_form don’t have all columns included. After clicking add and then on saving, Ledger table have blank reference of Book. It was working before, even when the column was not included in Ledger_form or show flag was off. I don’t want Book column to show in entry or inline display of Ledger. If enable the field to show in entry, it is automatically filling data based on the reference and working and picking data.

Try removing the Related Ledgers column from the Book table and let AppSheet recreate it.

1 Like