Multiple selections in listbox to create separate records in table

[jobbie]

I am trying to create a form based database to store links to various pdf documents. These files belong to one or multiple projects. So I have created a form with a list box which shows the various projects and and a text box which has the link to the pdf but the problem is when multiple projects are selected the information is not stored in the table as separate records. How should I go about doing this? For example if one pdf file refers to 2 projects X & Y and if a user selects these 2 projects in the list box and enters the path of the pdf in a textbox it should create 2 records in the table:

Project	Path
X	C:/Sales/X
Y	C:/Sales/Y

[orange]

sounds like a 1 to Many set up

1 Project can have 1 or Many related pdf documents.

tblProject---->tblProject_PDF_Files

This would use a Form/subform arrangement.

Search the forum for examples --there are several here and on youtube.

[jobbie]

sounds like a 1 to Many set up

1 Project can have 1 or Many related pdf documents.

tblProject---->tblProject_PDF_Files

This would use a Form/subform arrangement.

Search the forum for examples --there are several here and on youtube.

I don't think it's a form/ subform or one to many problem. I just need a way to select multiple items and save them from a list box. I found the solution to the problem. I am pasting the link for future reference. Thanks

http://bytes.com/topic/access/answer...ual-rows-table

[orange]

Good stuff. Thanks for posting your solution -seems good to me.