Use of Option Buttons

[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.

 

[Jeanette Cunningham]

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