Based on User Selection in a form, create new records for subsequent form

[duthiedon]

Looking for coding help (and perhaps an example) that would help solve the following. Any help is greatly appreciated.

The user will be creating a new project that contains a bunch of releases. The releases have standard names which are stored in a table tbl_ReleaseNames It should be noted that the list of names is not static.

The user selects which of the releases pertains to their project and then based on their selections, new records would be created in tbl_RFP_Release and then a subsequent form would open where it would display each of these newly created releases where they could enter additional information.

I thought of creating an unbound checkbox associated with each of the standard names, and then checking to see if the checkbox was checked and then creating the new records followed by opening up the new form. Just not sure how to go about it.

Any help?

 

[jdraw]

Can you step back a little and describe the "issue/opportunity" in plain English just til we understand WHAT you're trying to do? Then the options and advice will be posted. Maybe a few examples showing a few Projects/name and what a release looks like/would contain.

 

[duthiedon]

The issue is that I have multiple values (release name) that a user needs to select which ones apply to their project. If they apply to their project, then the value (release name) needs to be copied to a new unique record created in another table. Each of these value creates a new record, so I could possibly end up with multiple new records. Once these new records are created, then a new form would allow the user to add additional information.

 

[pbaldy]

Would this work for you?

http://www.baldyweb.com/MultiselectAppend.htm

 

[jdraw]

I'm missing your intent.

You have Projects; those projects have an attribute that represents the type of release such as XXXX, YYYY, BBBB
A Project may have 1 or more of these attribute values.
Seems like a one to many set up....
What does a release represent?
new version of software/hardware
????

Maybe a few examples showing a few Projects/name and what a release looks like/would contain.

 

[duthiedon]

Thank you very much pbaldy! That was EXACTLY what I was looking for. Just adapted the code to suit my database, but it worked!

 

[pbaldy]

Happy to help!