Entering same value in multiple records

  • Thread starter Thread starter Ramesh
  • Start date Start date
R

Ramesh

Hi,

I have a table with Batch No. and Reg No.

Can I make a form where I can enter the Batch No. once and subsequent new
record contains the same Batch No. and then I can enter only the Reg No. of
students in that batch?

This will save me from typing the same batch number so many times for each
Reg No. in that batch.

Thanks very much.

Ramesh
 
Batch Number (BatchNo) should be a primary key in its own
Table( ? tblBatch) and then a foreign key in the Reg No
Table (? tblReg) Reg Number (RegNo) would be the Primary
Key of tblReg

You can have !BatchNo in the main Form and !RegNo in a
SubForm with the Primary Key BatchNo as the link to the
Sub Form.

Set up a one to many relationship and enforce referential
integrity (Tools relationships)
 
Back
Top