Jarichardusa
New member
- Local time
- Today, 02:35
- Joined
- May 23, 2020
- Messages
- 19
Please excuse me as I try to make my request clear. I'm not an access guru of any sort. I have a db I've created to track jobs I complete for customers. Each job could possible result in a tip from the customer. Tips are tracked in a table: tblTips which has the fields: TipID, TipDate, Gratuity, and Delivery_ID. There is a one-one relationship between TipID and Delivery_ID. Right now, no record gets created into this table unless I add the tip information for the delivery. This is causing issues with other portions of my db forms where I'm trying to calculate certain things, and those things involve the tip amounts, but if there are no tip records to be had in the results of the particular filter I run, then the calculated fields on the form just stay blank. I've tried to find a way to just set a default value of 0.00 on the field of the form that calculates the total tips for filtered range, but since it is a calculated field, I can't do that, at least I can't get it to work. So, what I have surmised, is that the only way around this would be to have a Tip record automatically created in tblTips as part of the Save Record button code when I save the newly created delivery utilizing the The Delivery_ID would be the DeliveryID of the record I just created, the TipDate would be Today and the Gratuity would be simply 0.00. Any help would be appreciated. I looked up append query was just royally confused, and not sure tha would be how to do it in this case.