Search results

Thank you CJ but the problem is that, when I want to show the father1 details along with the family details in subform

Can you please tell me how to maintain the relationship between each member

Thank you boblarson.

I will explain the scenario, I am creating a MS access database for my church people. In this database, I am storing all the church member details in one table when I want to show the details of the member in form along with his family members details I have to show them in subform. for eg...

I want to create ms access database for church In this database I have to store the memeber details and family details of the member for eg: father1 is member, he had three children son1 son2 daughter1 if son1 got married then he will be member so, here the problem is need to store...

Thank you john, but In the videos there are using different table In my case only one table data need to display in main form and sub form, by using "relation table"

Can any one help me, I have form where I will show the details of one table(member details table) In same form I have subform where I can get the member family details (here I am using the relationship table), now my problem is when Member detail form open based on the member id, the below...