Entering same value in multiple records

[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

 

[Doug]

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)

 

[Ramesh]

Thanks Doug. That worked simply and beautifully.

Warm regards
Ramesh