Showing records from a link table collectively?

D

Dan Neely

Instead of using a datasheet or continuous form to show a number of
link table records sequentially is it possible to filter on one column
and then show every record the contains a specfic key with a multiple
select listbox.

eg the link table consists of two columns with values, and the foreign
keys for both columns having values other than the ones displayed here
(eg 0-9, A-Z):
1 A
1 B
1 F
2 C
2 D
3 H

I'd like to be able to let the user select 1, and have a multiple
select listbox show A, B, and F as selected. IF the user were to
select 4 there wouldn't be anything selected in the listbox at all.
FI possible I'd like to be able to add or remove records by changing
the selections as well.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top