Toggles and forms

[Guest]

i'm trying to create a database of Staff names and contact details. Due to
the nature of the form it has 103 individual toggle buttons on it which each
represent a different building. What i would like it to do is that when the
form is filled out i can use the toggle buttons the select which building i
would like the persons details registered against.

Heres the process-
I currently have 2 tables,
Table 1 is the information about the buildings (Name, building number,
procedures and a box for Emergency Contacts)

Table 2 is where i list my emergency contacts using the form designated for
it. It stores: Title, Initials Surname and currently has 103 extra fields of
yes/no type.

when i select the toggle how can i tell the database to basically include
the persons details in the emergency contacts box on table 1? (and remove
them when i uncheck the box)

 

[Arvin Meyer [MVP]]

Instead of 103 toggle buttons (what happens when building 23 and 36 get
destroyed, or 5 more buildings are built?) Use a combo box to select which
building you want and another to select which person you want. Store that
information in a third table that has only those 2 fields. Now, 1 building
can have many emergency contacts, and they can be recalled in a priority
order, if you wish; and 1 person can be the contact for many buildings, with
different priorities. You can now also add or substract as many buildings as
you wish, and add or subtract as many people as you wish.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Thanks a lot! (just realised i didnt reply or say thankyou!) you were
absolutely about that and i have changed my method completely. the combo list
for buildings is fine but for people....no way.... i have 50,000 people in
the database! hehe. each person has a staff number though so i use that as a
search meathod and it brings up the appropriate person.

Thanks again for helping me realise 103 toggles was completely stupid!