Multi Records

[taloker]

I am using Access 2007
I have two tables
1.Students with Group & Name fields
And
2. Bus with Group & Name fields
I have different students in groups for example 5 in Group B and 7 in Group A
What I wish to do is when I enter the group like A on Bus form all the data (Name & Group) of 5 students is populated in bus table
I am pleased if some body helps me


Taloker

 

[Cronk]

Use an append query.

If you want something more specific, you will need to be more specific about your table structure, including names of fields and field types in your tables.

 

[taloker]

Use an append query.

If you want something more specific, you will need to be more specific about your table structure, including names of fields and field types in your tables.

Sir thanks for quick reply but I want this job to be done on form can we use Append query threough Form?

 

[Cronk]

Yes, you can add records based on an append query activated by an event in your form.

If you want something more specific, you will need to be more specific about your table structure, including names of fields and field types in your tables.

 

[taloker]

thanks I will try and let you know with out come

 

[taloker]

I have table of students with a field GroupID like diffrent nos of students in one group like 5 in Group A 6 in Group B and 3 in Group C What I want is that when I click or update Group ID the all student data under that Group is added to specific table. If we update Group A all 5 student data is updated in defined table