Goal: To fill in the child form from the family form when there is no entry in the child record.
I have a contact table with phone and email.
Today, every one in the family has their own cell phone number.
Thus I made a family member table with name, phone and email.
I complete the contact table first and there is a browse within that form for the family members
As you enter a family member, it is looking up the key and entering the same key in the family member record. The user enters the name of the family member. I'd like to copy the phone and email from the contact table subject to override in the family member table.
I made a field rule for the key field in the family member record. It presently does fill in the key. I have also told it to fill in familymemberphone from contactphone if isblank("familymemberphone") with or without the condition, I don't get the phone number or the email copied.
Similarly, I have an actor table which lists the shows that the family members were in. It has fields, Last (key), First, M_F, Child, LastAudition, LastCast, Show
I am getting the drop down for show name and date to work just fine, one picks from the various shows.
I'd like to get the First field to drop down a list of the family members with the same last name so that the user can chose which family member and it will automatically fill in the first, M-F and Child from the familymember table. My drop down now shows all familymembers from all families. I have the set defined so that there is a one to one link from actors to familymembers and the link is based on the mutual key Last. How do I get the drop down to show only the familymembers with the same Last key?
Thanks for your help
Jim
Vero Beach Theatre Guild
I have a contact table with phone and email.
Today, every one in the family has their own cell phone number.
Thus I made a family member table with name, phone and email.
I complete the contact table first and there is a browse within that form for the family members
As you enter a family member, it is looking up the key and entering the same key in the family member record. The user enters the name of the family member. I'd like to copy the phone and email from the contact table subject to override in the family member table.
I made a field rule for the key field in the family member record. It presently does fill in the key. I have also told it to fill in familymemberphone from contactphone if isblank("familymemberphone") with or without the condition, I don't get the phone number or the email copied.
Similarly, I have an actor table which lists the shows that the family members were in. It has fields, Last (key), First, M_F, Child, LastAudition, LastCast, Show
I am getting the drop down for show name and date to work just fine, one picks from the various shows.
I'd like to get the First field to drop down a list of the family members with the same last name so that the user can chose which family member and it will automatically fill in the first, M-F and Child from the familymember table. My drop down now shows all familymembers from all families. I have the set defined so that there is a one to one link from actors to familymembers and the link is based on the mutual key Last. How do I get the drop down to show only the familymembers with the same Last key?
Thanks for your help
Jim
Vero Beach Theatre Guild
Comment