Fill in data

[Blythe]

Where I work we are required to registar are cars. Each car has a number
hanging from a tag in the car. If you are parked in the wrong spot then the
security officers will write you a ticket, which is then entered into a
access database. I was wondering if there is a way to have access enter the
phone number, make model of car and licen plate number and name of the
person.

Example:
Permit number 123 belongs to Jane Doe. When I enter the ticket I would lilke
to be able to type in the permit number and acesss to enter Her name and
Phone number by hitting enter or something.

 

[Wayne-I-M]

If the permit number never changes
Add the permit number to the table containing all the persons details

If the permit does change
Create a table with permit numbers
You may want
Permit number (primary field)
PersonsID (linking field)
Permit valid from
Permit valid to
etc

Link this table with the table containing the persons details.

Create a form based on the (either) above

Use the wizard to create a search box on yur form