Hi there, I run a charity with volunteers who help feed and medicate local street dogs in Thailand. I am trying to create a database to keep track of their medical expenses. There are two types of expenses at the vet: medicine and vet fees. I’ve created an “Order” table, which connects to two respective “Line Item” tables (medicine & vet fees).
In main grid view, the Order table works as expected. For example, I can create a new order, then add line items for medicine and or vet fees. Then those line items are rolled up and gives a grand total.
The problem is in using the Form view on the Orders table: I can add existing records, but cannot create new ones, which is necessary. I really would like to use Form view so that my volunteers can enter data easily without really having to get involved with the grid view.
Also, it would be really useful if the form could display calculated fields. This could show calculations like Grand Total. These calculated fields simply do not appear at all.
Below is a read-only access link to my database. Feel free to copy the data into your own test instance so you may better understand my problem.
Thanks so much to whoever can help! The street dogs thank you too!