Based on main form id, subform data should be shown (1 Viewer)

jsampath7 · Mar 19, 2013

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 subform data should be fetched

John Big Booty · Mar 19, 2013

Perhaps the tutorial here will help you out.

jsampath7 · Mar 20, 2013

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"

John Big Booty · Mar 20, 2013

If you only have one table why do you need a sub form

jsampath7 · Mar 20, 2013

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:

father is member, he had three children

son1
son2
daughter1

if son1 got married then he will be member

so,
here the problem is
based on the relationship need to show data

I have relationship table , where it will store the relationship between family member

boblarson · Mar 20, 2013

You need more than one table. I responded to your other thread and pointed you to the data models here:
http://www.databaseanswers.org/data_models/

You should not have repeating fields (like son1, son2, etc.).

Those go in another table.

jsampath7 · Mar 20, 2013

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

Based on main form id, subform data should be shown (1 Viewer)

jsampath7

New member

John Big Booty

AWF VIP

jsampath7

New member

John Big Booty

AWF VIP

jsampath7

New member

boblarson

Smeghead

jsampath7

New member

Similar threads

Users who are viewing this thread