S
Stephanie
Hi. It's been awhile since I've had to change my setup and seem to have
forgotten a bit! Here's my current setup and how I need the form changed:
A group of members have the same registration expiration date (it used to be
that they had the same expiration month, but the actual date could vary).
Members need to recertify every other year, so a long time member will have
many certification dates and I need to keep track of all of them.
I have two tables:
NatlCetTests
NatlCertTestID
TestDate
NatlCertResults
NatlCertResultsID
ContactID
AnimalsID
NatlCertDate (this is when the date could vary)
NatlCertTestID
I have forms:
frmNatlRegExp which has the NatlCertTests TestDate field (this was for
"months", but has been changed to be the last day of a given month)
then I have a form that has the NatlCertTests TestDate field at the top,
with a subform that shows the "results" for each person based on
NatlCertResults.
What I'd like to do is for each member is to have the associated TestDate
field at the top of the form default to the subform in the NatlCertDate
field. But I want to store the actual date for each member.
And I seem a bit confused about the change. I'd appreciate table and form
setup advice. Thanks!
forgotten a bit! Here's my current setup and how I need the form changed:
A group of members have the same registration expiration date (it used to be
that they had the same expiration month, but the actual date could vary).
Members need to recertify every other year, so a long time member will have
many certification dates and I need to keep track of all of them.
I have two tables:
NatlCetTests
NatlCertTestID
TestDate
NatlCertResults
NatlCertResultsID
ContactID
AnimalsID
NatlCertDate (this is when the date could vary)
NatlCertTestID
I have forms:
frmNatlRegExp which has the NatlCertTests TestDate field (this was for
"months", but has been changed to be the last day of a given month)
then I have a form that has the NatlCertTests TestDate field at the top,
with a subform that shows the "results" for each person based on
NatlCertResults.
What I'd like to do is for each member is to have the associated TestDate
field at the top of the form default to the subform in the NatlCertDate
field. But I want to store the actual date for each member.
And I seem a bit confused about the change. I'd appreciate table and form
setup advice. Thanks!