I am creating a client database for my Dog daycare and i am running into a couple problems with linking fields and forms. I have one form called Customer info and this form has fields for name, Dog's name, number, email, Daily Credits and a sub form for vaccination records. MY second form is called Dog account/payment history. This has a look up field for Dog'ss name, a radio button for Checkin/Checkout , a payment field, and a Credit field. I would like to link a couple items:
1. I would like to have the Daily Credits show up on my Second form when the Dog's name is selected from the look up field.
2. I would like to have one Credit Subtracted each time i select Check out on the Radio button.
3. I would like to have all payment info sent to a third Form dedicated to storing Payment history for each Dog. So When a payment is entered it is transferred to a Third Form With the Dog's Name.
Is this stuff possible? im sure it would have to be done with Functions or Script but i cant figure it out.