Structural Problem - How to choose multiple items to add to an Invoice?

I have Appointments. Each Appointment has multiple Invoice Items (since Appointments are only ever invoiced once, they double as the invoice). Available Items to add as Invoice Items come from a…

Determine if linked record's Multiple Choice contains value from this record's Choice field

This record has a Choice field with two values: Cat, Dog and this record (obviously) can only be one or the other. This record has a linked Colouring table where each record has a Colour (text) and a…

Two Serious Problems... Required Fields & Trigger on new record/update

I just realized there are two serious problems that might be deal-breakers for my business. 1. Required fields don't seem too required. That is to say, I can close a record and it saves (because it…

• Answered