Help Needed!

[BSmith]

Ok...I've been an avid reader of this forum for over a year. I've learned ALOT from all of you guys/gals.

Now, I'm stumped and I hope someone can help me.

I've been tasked with creating a "new business database" that will allow for users to select an "aircraft type" and then create and "estimate" on work to be done.

My problem so far is when opening the "selection1" form and then selecting "VC-25A" then "Create Visit" then "Service Bulletin(s). It will show a multiselect listbox of bulletins and thier corrosponding hours.

I would like to be able to select which bulletins I wish and then have them be placed onto a seperate form in which I will be adding other items to create a "total" estimate from.

I know this all sounds clumbsy. But, I've been working on this for 12 hours straight and I'm ready to swallow some cianide.

I'm attaching the DB so you all can see what I'm talking about.

I thank you very very very much for even reading this, much less offering me some assistance.

 

[Pat Hartman]

Whenever you have a 1-to-many relationship (1 aircraft to many bulletins) you will find it much easier to use a subform than a multi-select listbox. The suborm allows the user to select whichever bulletins are relevant and they are automatically added to the many-side table. With the multi-select listbox, you'll need lots of code behing the form to process the listbox and then run append queries to append the selected bulletins as rows in the many-side table.

 

[BSmith]

Thanks for the reply Pat.

Do you think you may be able to show me an example of what you're talking about? I can't visualise it. Thanks alot!

 

[Pat Hartman]

Take a look at this sample db that I posted some time ago:

http://www.access-programmers.co.uk...hreadid=52587&highlight=manytomany+AND+sample