Access 97 forms

  • Thread starter Thread starter Sameer
  • Start date Start date
S

Sameer

Hello everyone,
I am trying to develop a form that I need help with. I
have a table called OptInOrOut that has a ContractId,
PersonId and InOrOut. There are about 100 people and 100
contracts, so the size of the table is about 10,000
records and each person's record has an InOrOut boolean
value.
On the form, I am trying to have a drop down button on top
where the contract can be chosen. Once a contract is
chosen, I would like to see only the 100 person records
for that contract and be able to data entry the InOrOut
for each one.
Any help in this direction will be appreciated.
Thanks
Sameer
 
Read up on normalisation.

You need 3 tables.

tblPeople
PersonID ( primary key )
etc - other fields describing the person

tblContracts
ContractID ( primary key )
etc

tblOptions
PersonID - foreign key to tblPeople
ContractID - foreign key to tblContracts

Then you only need 100 entries in the people table. 100 entries in the
Contracts table, and as many entries in the tblOptions table as there are
active People with Contracts ( surely a lot less than 10,000 ). You dont
need the boolean, since you only make an entry in this table when a Person
has a Contract.

Setting up a form/subform to allow editing and entry is then very easy.


--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top