On 2008 Jun 6, at 13:40, Stacyann Forrester wrote:
Hi Everyone,
I would like to create a Master database for contact management
that is
associated with a sub-database for related contacts. I would like
to add
new records only to the Master database and have it populate the
sub-database if applicable to the sub-database created.
Does anyone know how to create such a relationship?
Thank you,
Stacyann
Stacyann, I work with WAGS (Wisconsin Academy of Graduate Service
Dogs), and it has a requirement which seems identical to yours. Every
time they create a new record for a dog (which starts in early
puppyhood), they also need to create a series of associated records
for various medical procedures which need to be performed when the
puppy reaches certain ages. I've got this set up as a script that's
activated by clicking a button after the new "Dog" record is created.
If you wish, I can send you a clone of the database so you can peek
under the hood and see how it's done.
Let me know directly at [EMAIL PROTECTED]