I have a table, we’ll call it “Table A”, where I capture all of the medical history of a select population (it’s dogs, in case anyone was wondering). A dog’s complete medical work up happens over a series of appointments. So I have a second table (Table B) that keeps track of medical appointment requests and the services that were requested on an appointment basis. So quick recap, Table A = dog basis, Table B = individual appointment basis. There are several fields in Table A that we tract the dates which services were performed (so Rabies vaccination given 10/15/2020 for example). Since many services can be performed in a single appointment, I’d like to automate the population of the fields in Table A that correspond to appointments in Table B. But I also need the flexibility of being able to manually enter values into Table A (so look ups won’t work for me).
I cannot figure out how to get my “Appointment Dates” in Table B to populate individual service dates in Table A. I’ve figured out just about every other automation (check boxes, text, etc.) but cannot figure out dates. Help!
In case it’s relevant, my field in Table A is day only, whereas the field in Table B is date and time.