Multiple selects and records store

xcao

Registered User.
Local time
Today, 17:28
Joined
Nov 25, 2003
Messages
40
I'm creating an Access data entry form for computer installations.

Basically the entry form will choose a software and license, then select one or more computers to install the software on.

Then later we can create a report that can track what softwares are installed on the computers, or track what computers has what softwares.

Now my question is for each record of the installation entry form, after we select the software, then we will choose a computer name or more computer names.
If just one computer is easy, but how can I choose multiple computers, which control should I use? and how can I store the computer name list in the installation table, do I have to make each computer installation a record in the table or put multiple computer names in one record in the field like memo, but if I use memo, later it seems i cannot group or search memo field?

Can anyone give me some ideas about what is an easy design solution or samples about these?

Thanks a lot
 
I would store each computer as a record. It would be easier for future searches.
 

Users who are viewing this thread

Back
Top Bottom