form design problem

[bdj]

I am trying to design a staffing matrix contingency plan database whereby I can have staff identity details as the top part of the form based on a table (tblStaff) with StaffID, Surname, Forename and Office as entities

At the bottom part of the form I want to display every location entry from another table together with a series of 4 tick boxes for each location. I know how to create a subform but that is not what I really want as I need to display the information for a list of every location that is in the location table

The second table (tbllocation) consists of StaffID. Location, Bus, Walk, Train and Car – (Bus, Walk, Train and Car are all tick boxes).

This form will then allow me to record whether a member of staff can under emergency conditions, bus walk train or use their car to get to any of the offices in the District.

I realise that I could enter each individual location as a separate entry into a single table (ie tblStaff) but this would prevent the database being used in another District without modification. I would prefer to have a generic solution but I cannot for the life of me fathom out how to do it.

Any help would be most appreciated.

Brian Jermain
Scotland

 

[FoFa]

Why not have a subform with your tbllocation, and for the location, have a combobox to select the location from, based on the location contained in another table (you didn't specify).

 

[bdj]

Form Design

I realise this would be a solution but what I am trying to do is get all locations (in the location table) to appear in the input form with the tick boxes against each of the entries and not have to use a combo box to select up to 30 sites individually for inclusion in the subform.

It seems such a relatively easy problem but I cannot think of a reasonable solution