Re: Toggles and forms
- From: "Arvin Meyer [MVP]" <a@xxxxx>
- Date: Sun, 29 Jan 2006 09:39:34 -0500
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
"Coriron" <Coriron@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C9A6AE61-0780-4F13-9174-2B3362278723@xxxxxxxxxxxxxxxx
> 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)
>
> --
> Relatively new to Access
.
- Prev by Date: Re: Highlight a record on a continusform
- Next by Date: Re: Scrolling Records
- Previous by thread: Re: Builtin Functions not recognised
- Next by thread: Re: Bold font for partial string in test box
- Index(es):
Relevant Pages
|
