Opneoffice Base and Checkbox

[meccamw1701]

I am using Openoffice Base 3.0 and for my business where I am using it to enter orders for DVDs that my clients send me that I produce for my video production business. I have two tables (and OrderEntry table and a DVDEvent table.

The DVDEvent table contains all of the DVDs that I have available for sale and the OrderEntry table contains listings of the orders.

I have everything working correctly. My only issue happens when someone orders a DVD from a production after I ship the main order. I modified the DVDEvent table to add a Yes/No field to indicate when a particular item has shipped however, I have no idea how I can get the logic on my form to make this work.

I use a dropdown list item to populated from the DVDEvent table so ideally when I lose the focus on this list item I would like to check the status of the Yes/No field and if it is shipped either beep or put up a msgbox indicating to me that this has shipped so I can take a different course of action.

Any ideas how to pull this off?

Mark