Need some input

[AricC]

I'm trying to get some input on the best way to handle a situation I have. I have a form with a series of comboboxes ( approx 13 ) called Part#, I would like to make a seperate table called TPartNumbers, however each of the 13 drop down boxes has around 2-4 options. Does anyone have a suggestion on how I should do this? I was thinking 1 table but I may have to do multiple; also, I have thought about a listbox so I can display all the options, however if they pick more than 1I'm not sure how I would handle the multiple entries. I have a ton of tables already about 20 I'm not sure that I want to add another 3 or 4 not to mention I would be making tables like ( eg.. TPartNumbers1to5 ), any ideas or suggestions I may not have thought about? Any input appreciated!
Thanks,
AC

[MMcCarthy]

DON'T make a new table

Making tables just to hold data is pointless unless there is a very good reason for it.

What do you want to do with this data?

I can tell you how to handle multiple list boxes but I need to know if all the data is the same and what it's for

[AricC]

Thanks,

It's basically a repair form, the problem I'm looking at is for part numbers for every different product there could be a different part #, so say one product has a bad part depending on the product the part number could be 1040 ( or 1111 ..... 1115 ) A,B,J,L,S, or ... whatever. So there are about 13 combo boxes ( In the approach DB they were in columns part1, part2, part3, ... , part 13 ) with the part #'s with anywhere from 1 to 4-5 values per combobox, that may need a letter appened to the end of the value in the combo box. I was going to use a list box but no way to add anything to the values.
Thanks,
Aric

[MMcCarthy]

Thanks,

It's basically a repair form, the problem I'm looking at is for part numbers for every different product there could be a different part #, so say one product has a bad part depending on the product the part number could be 1040 ( or 1111 ..... 1115 ) A,B,J,L,S, or ... whatever. So there are about 13 combo boxes ( In the approach DB they were in columns part1, part2, part3, ... , part 13 ) with the part #'s with anywhere from 1 to 4-5 values per combobox, that may need a letter appened to the end of the value in the combo box. I was going to use a list box but no way to add anything to the values.
Thanks,
Aric

You can add to a list box:

For example:

Listbox called List1
Combobox called cboPart

To add an item to the list after selecting a value in cboPart put the following code in the On Click event of a command button cmdAddPart

 
Private Sub cmdAddPart_OnClick()
Dim strList As String
 
  strList = Me.List1.RowSource
  Me.List1.RowSource= strList & ";" & Me.cboPart
 
End Sub
 
 

If you need more than one column in the list box let me know exactly what you need and I'll post the code

[AricC]

I'll post the code so you have a better idea of what I'm talking about. I'll clean it up and pm it you can let me know what you think.
Appreciate the help!
Aric

[MMcCarthy]

I'll post the code so you have a better idea of what I'm talking about. I'll clean it up and pm it you can let me know what you think.
Appreciate the help!
Aric

Just thinking Aric

If you want to associate quantity, qa# or any other field with the part then you can move the fields form tblRepairs and put them in tblRepairParts.

This will associate them with the repair and the part rather than just the repair. Adjust the forms accordingly.

i.e. Remove them from frmRepairs and add them to the subform.

Mary