Selecting multiple records

H

hagen31

Hello,

I have two tables one stores computer informaiton, type of computer, etc.
The other one stores different software that can be used on any computer. Any
given computer will have many different software programs on it, and vice
versa. Can I create a form to allow me to select multiple software programs
that are on any given computer?
 
M

Mike

I would make the software table a subtable of the computers.

The subtable could have a lookup to a software list table to regualte the
data.

hth
 
H

hagen31

Mike,

How do you make a subtable?

Austin

Mike said:
I would make the software table a subtable of the computers.

The subtable could have a lookup to a software list table to regualte the
data.

hth
Click to expand...
 
H

hagen31

Mike,

Ignore that last post I got that. Now in order to add new computers I have
to go to by computer form, then go to my new form called Test right now and
add the software, correct? If so, will the new computer show up in the list
box so I don't have to type it in manually everywhere. I am going to test
that right now but just wondering.

Thanks,

Austin
 
H

hagen31

Mike,

Thanks for the help the rest of my blabbing was just thinking out loud. The
solution is not as slick as I would like, becuase in the subform you have to
scroll through every piece of software on any given computer, but the
solution does work and that is only a minor problem for the low number of
software that is on the computers.

Thanks for the help,

Austin
 
Top