Continuous Form do not repeat values in rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to track information about cars (tbCars). On a continuous form
for each day (day is entered in the header of the report). In report detail I
enter data about all cars which are used on a selected day. Each record
(row) starts with a combo box where user can select from the set of cars
(carID).

What I try to achieve is to protect users from selecting the same car twice
in the same day . Either user will get a warning message (this car was
already used today) or entered cars will disapear from the combobox
(preferable options)

any help is appricaited. thanks.
 
Cheap and dirty way is to open the table in design view - click on menu VIEW
- Indexes. This opens another window. In a new row type in a name for an
index (it does not matter what so long as it does not duplicate what is
there). Add the fields that is your combination of ID and date. Click in the
first field of the combination and than in the bottom part of the window
change Unique No to Unique Yes.
 
good idea but, in fact source for the form is a querry (one table bring
car's detail, the other table includes date)

I think I am not able to setup indexes on a querry.

KARL DEWEY píše:
 
Indexes are for tables.

Supicek said:
good idea but, in fact source for the form is a querry (one table bring
car's detail, the other table includes date)

I think I am not able to setup indexes on a querry.

KARL DEWEY píše:
Click to expand...
 
Back
Top