Help I've created a Monster with limit to list!!!!!!

[Darryn]

The saga continues with my outdoor equipment inventory system!!

I have a main equipment form and an employee form, for expediency I
put a combo box on the main equipment form to lookup the employees
table so the users could easily assign gear to an instructor. On the
Employees form I have a subform which lists the gear that is assigned
to them.

The field is called EmployeeID, so I had the bound column hidden and
the last name, first name fields concatenated so they are visible in
the combo. The combo is set to limit to list

As soon as I started populating the table I noticed that I needed to
add an entry to assign the equipment to an employee. I thought that I
could just add a dummy employee but the dummy employee ends up with
about 1300 records in their subform once I import all of the data!!

Is there any way of not requiring an entry in this field. In the
equipment table EmployeeID is not required

I also had a cunning? idea to set the limit to list property of the
combo to no and disabling the combo but had no joy with either.

Any suggestions?

Darryn

 

[Darryn]

The saga continues with my outdoor equipment inventory system!!

Sorry to bother you all with this, sometimes it helps to sit down and
think a bit before panic sets in!

I had referential integrity turned on for the relationship between
equipment and employees, as it is not a super critical thing I have
disabled it and 'Voila' no more problems

Sorry again

Darryn