Trying to Learn Relationships
Trying out the trial version and have done the followoing.
1. Set up a database with the following tables: Members Information, Spouse Name, Dependent TAble
2. Added fields
3. One field in the Members Information is a number field which auto generates a serial number
4. I created a relationships between this field called "customer ID" to other customer ID fields in the Spouse table and the Dependant Table.
5. I was expecting that when I entered a record in the Members table the self generating number of teh "customer ID" field would auo matically populate the Spouse and Dependenta table customer ID fields. It doesn't.
6. Can someone help me understand what I ams doing wrong