Copy Address, city ,satste zip from one lay out to another

First a question: will all dependents have the same address or will some have different addresses?  If they will all have the same address then you should delete the address fields from Dependents and just use the address in Insured.

 If different addresses then, do some of the dependents use the Insured address and if that changes it will change for all of them? In that case you may want to have address fields in Dependents but also a "Use Primary Address" checkbox field that indicates you should use the Insured" address

Merry Christmas Will,

What I like to do it the following...

I created two tables,
1-Inusred
2-Dependents

On the Insured table I created a PKInsuredID
On the Dependents tables I created a FKDependentsID

I created a relationship between the PKInsured to the FLDependents

I want to do the following...

On the Insured table I created fields for  First Name. Last Name, Address, City, State & Zip
On the Dependents tables I created  fields for  First Name. Last Name, Address, City, State & Zip

I want to be able to create a button or a script on a button that will allow me to check if it's a check box or press it if it is a button and the address, City, State 7 Zip from the Insured table would appear on the Dependents  address, City, State  & Zip field.

I also created a Portal on the Insured table that I want to be able to display the First Name, Last Name, SS#, DOB & Age from the Dependents table. I created the portal and add the fields, but nothing is showing

My idea is to input the info for the primary insured on the Insured table and then input his dependents on the dependents table. In most cases the dependents live with the insured so I want to have a button or check box to allow for quick input by coping the address, City, State and Zip fields form the Insureds table to the fields on the Dependents table fields.

The idea behind the Portal is when viewing a record I want to be able to have a quick reference of the dependents of the user by having the First Name, Last Name, DOB, SS# & Age of the dependents on the Portal on the Insureds table.

I can't seems to be able to do any of the two ideas, what I'm I doing wrong?
How can I correct it?

Thanks for all of your help.

The quickest way to explain and de.monstrate  what you need to do will be for you to upload a sample file.

Here you are....

Here
Insured.fmp12

Thanks Will...
I upload the file....
If you have the time can you explain what you did or what I was doing wrong?

Thanks

Thank you very much for all of your help Will...

Will,

There is a problem with the db, it only calculates the total number of dependents, the primary has to be part of the calculation...
How can I change that?

If the Primary has a "Dependent" record, which as I mentioned is how I would set it up, then it should properly calculate the number of Dependents. If you want it to calculate the Dependents less 1, then just include -1 in the Dependents Count() calculation.

Ok...
Thank you

Hello Will,

Here is the problem that I see....
When I fill out the dependents name it should add the primary as a member with $125.00 monthly charge, it dose not...

can we do this as a separate question?

sure...