I WANT TO CREATE SUB AND SUB SUB TABLE IN MSACCESS

Question

I WANT TO CREATE SUB AND SUB SUB TABLE IN MSACCESS

Ahmed Kutty 40

I WANT TO CREATE DATA BASE IN ACCESS ON THE BASIS OF ATTACHED TABLE OF MSEXCEL. IF YOU WANT MORE DETAILS FROM MY SIDE WILL FORWARD TO YOU.

User's image

Moved from: Community Center | Discuss the Q&A site | Get started on Q&A

George Hepworth 22,220 Reputation points Volunteer Moderator

2025-12-10T14:53:43.84+00:00

Unfortunately, because the language is not English, most English speakers will not be able to figure out the topic it covers. Moreover, we have no insight into the business rules that apply to the data.

So, help us help you. Explain, using terms that are accessible to English speakers, what this is all about.

Or, see if you can find a language specific forum where participants know the language used in the screen shot.

By the way, typing in ALL CAPS is considered shouting in forums. Many forum participants don't like being shouted at.

2 answers

Your answer

George Hepworth 22,220 Reputation points Volunteer Moderator

2025-12-10T14:53:43.84+00:00

Unfortunately, because the language is not English, most English speakers will not be able to figure out the topic it covers. Moreover, we have no insight into the business rules that apply to the data.

So, help us help you. Explain, using terms that are accessible to English speakers, what this is all about.

Or, see if you can find a language specific forum where participants know the language used in the screen shot.

By the way, typing in ALL CAPS is considered shouting in forums. Many forum participants don't like being shouted at.

Answer 1

Gabriel-N 9,875 Microsoft External Staff Moderator

Dear Ahmed Kutty

Thank you for posting your question on the Q&A forum. Based on the information you provided, here are the steps to create your database in Microsoft Access:

1> Create Three Tables : tblGroups | tblMembers | tblTransactions as below picture

User's image

2> Set Up Relationships

Go to Database Tools > Relationships and add all three tables.
Drag GroupID from tblGroups and drop it on GroupID in tblMembers (check Enforce Referential Integrity).
Drag MemberID from tblMembers and drop it on MemberID in tblTransactions.

User's image

3> Create Forms for Each Table by going to Create ribbon > Form.

For tblMembers and tblTransactions forms: Switch to Design View, press F4, click the top black square, and change Default View to Datasheet. Set Allow Datasheet View to Yes, then save.

Change the form view of these two tables into Datasheet View.

User's image

4> Summarize Data: In the tblGroups form, after entering all data, simply click the Totals button in the Home ribbon to sum values.

User's image

Please try these steps and let me know if you encounter any issues or need further assistance.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Ahmed Kutty 40 Reputation points

2025-12-10T16:00:16.4766667+00:00

Little bit confused. Is there 3 tables?

I know basic of msacces. Not very expert. That is the reason I confused. Join date no need. Would appreciate in case I will get good idea on this. I dont know how.

I strongly believe the tblMembers table is sub table of tblGroups.

tblTransaction table is sub table of tblMembers.

Please can you support me from the beginning to end until complete this.

I feel you 3 tables are ok for this database.
Gabriel-N 9,875 Reputation points Microsoft External Staff Moderator

2025-12-11T07:48:53.06+00:00

Dear Ahmed Kutty

Thank you for clarifying your requirements.

To create the “Sub and Sub-Sub” structure you want, you definitely need three tables, and the relationships will make tblMembers a sub-table of tblGroups, and tblTransactions a sub-table of tblMembers.

The answer I provided earlier includes the full setup steps. Have you had the chance to try setting it up as described?

If you still need support from the beginning, could you let me know specifically which part you’d like help with?
Gabriel-N 9,875 Reputation points Microsoft External Staff Moderator

2025-12-12T09:02:28.9+00:00

Dear Ahmed Kutty

May I know if you have got any chance to check my reply? I am glad to help if you have any other questions

Answer 2

Ahmed Kutty 40

Little bit confused. Is there 3 tables?

I know basic of msacces. Not very expert. That is the reason I confused. Join date no need. Would appreciate in case I will get good idea on this. I dont know how.

I strongly believe the tblMembers table is sub table of tblGroups.

tblTransaction table is sub table of tblMembers.

Please can you support me from the beginning to end until complete this.

I feel your 3 tables are ok for this database.

Share via

I WANT TO CREATE SUB AND SUB SUB TABLE IN MSACCESS

2 answers

Your answer