So the title of this question may be deceiving. To start with, I attached the file I am working on so that you can follow along as I explain. So I have records under the Data layout which can contain multiple Mice, and for each Mouse I enter some data such as Date and Size. What I would like to do, ideally, is if I have multiple mice for a record, I would like the Dates from Mouse 1 to automatically appear for Mouse 2 and Mouse 3, etc. It would just save me a lot of time when entering data. I only want this for the Date, not the Size. Can anybody help with the easiest way to do this?
p.s. Full disclosure: I had help making the file up to this point. So I know as I add Mice it corresponds with another layout, but I am not sure how, sorry if that is an issue. I am sure you guys know better than me.