MultiSelect for List Box 1

[frog40]

I have read (and tried) many suggestions on this subject, but cannot seem to make it work. I feel as though I am missing the ORDER of programming. This is what I have:
Problem #1:
Table 1 - idsID - AutoNumber - Key
This Table has a One to Many relationship to
Table 2 - ingzID - Number - Key
Table 3 - ingzID & LineNumber - Number - No Key
this (Table 3)is a Lookup Table and I also want to store the ListBox MultiSelect items here.
Table 4 - ingzID & LineNumber
this table (Table 4) is a Junction Table to set the relationship to Table 2 & Table 3. I read that I need to have a Many to Many relationship in order to store items from a MultiSelect ListBox. I am unable to connect to a Many to Many (I can only connect to a 1 to Many)relationship.

Problem #2:
Table 2 is my main Database Table. I want to use (in a form) a List Box MultiSelect to store several Items into Table 3. I have set the MultiSelect Property to Simple and to Extended. I have tried a simple VBA command, and an extensive VBA command, but nothing works. Somehow I have gotten way off the track and am very confused by all the "pieces" that I am trying to put together.

If someone could give me a good "map" of how to put these pieces together, I would really appreciate it. Thanks in advance.

 

[PHV]

Have a look here:

http://r937.com/relational.html

http://www.devshed.com/c/a/MySQL/Understanding-SQL-Joins

I quite don't understand what you want to do with a MultiSelect ListBox (instead of a continuous subform).

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SeeThru]

You can't actually 'save' the values in a multiselect box (at least in Acc97). What I tend to do is use the selected values to generate something that is saved in a single field.

I suppose you could use the selected values to generate new records in a table.