Use of Option Buttons

  • Thread starter Thread starter Dick
  • Start date Start date
D

Dick

I have a main form where I display a record and associated fields. One
of the fields is called 'source'. Currently, the source is linked to
a one-to-one source table. No problem with this setup. However, I
want to be able to assign and display multiple 'sources' for each main
record. This ends up being a many-to-many relationship and,
therefore, I have created the following tables (not all fields are
listed).

Program Table
Prog_ID
Program_Name

Link Table
Prog_ID
Source_ID

Source Table
Source_ID
Source_Name

I want to display on the main form 'buttons' indicating which of the
many sources have been selected rather than showing the results in a
datasheet view. Is that possible, and if so, how do I do this? I
currently can display the the information using a subform in datasheet
view. But this only shows matching records based on the Link Table.

Thanks in advance.
 
Dick,
using the subform datasheet for the moment, it would show all the sources
used for the currently selected program.
If you could use a query that pulls the names of the sources into a separate
query based on the subform's recordsource and selected to show Unique
Values, you would have a list showing each source only once.
An option group is not multi-select - it will only show one value at a time.
If you had a list of all possible sources on the subform, you might be able
to use conditional formatting to color the ones that match the current
program.
I haven't tried this - it is just a suggestion and may not work - or you may
be able to invent a variation of this idea.

Jeanette Cunnningham
 
Back
Top