Help with Design

[RachelBedi]

Good Afternoon Folks,



I'm building a database with several many to many relationships, I have created a main form from which you can view information. I have also created a form in which to enter information. There are two particular fields in which you may be able to add more than one data point. As a run down. You have a PMID and a DMID these are identifiers for an account. You will have only one PMID but could have several DMIDs for the same PMID. What I need to do is create a form in which you can enter all the different DMIDs pertaining to that particular PMID.

First Issue:

I would love to open the form and have a single text box, as the user needs it I would like for them to be able to "add" text boxes in order to add additional DMIDs if necessary.

Second Issue:

I would like the text boxes to be unbound and on the click of a button to allow the user to insert as many text boxes as they have created into a separate table of DMIDs. I do have the insert into statement but am not sure how to get it to loop through all available text boxes.

Thank you for any help!

[ssanfu]

I would use a main form/sub form that is bound. Why use a unbound form/controls?

[orange]

I agree with Steve.
From your post

You will have only one PMID but could have several DMIDs for the same PMID.

Which is a standard 1 to many. Form/Subform is the answer 99% of the time.

Good luck.

There is a youtube video on form/subform at
https://www.youtube.com/watch?v=YZKN_-P6wck