HELP PLEASE 1

[tatika]

I have created a table called Equipments that lists many different types of equipments.
My goal is to create a form that lists the equipments by name . Example: microphone (in a check box) and quantity required (on a text box)
My goal is to have each equipment selected placed on table Equipment.
Should I create one record per equipment? If I do, I'll have blank record and no primary key value.

Hope someone can help me.....

 

[grnzbra]

First of all, do you really mean "check box" which is a yes or no kind of thing or do you mean a combo box which is also known as a dropdown box?

In any event, you should have a table with a line for each piece of equipment, a key field which could be an auto number field or some other thing if you want a key which tells something about the equipment (like Axxx for Audio equipment and Vxxx for Video equipment).

You have a field for quantity required. Does this represent a minimum number required to be kept on hand (which could go on your equipment table) or does it mean the quantity required for a particular job or project? If it is the minimum required for a job or project, you are talking about haveing a Project table which would give particulars about the job or perhaps you would have an equipment required table which would match a job up to a list of equipment and quantity required for the job.

 

[docmeizie]

Well basically with the information that you have provided, you would be just duplicating data with another table called Equipment. Now it would be better for you if you could give use more information. For instance; does a project need this equipment to be completed, or does a person check out this equipment???? All we can really do is take a stab in the dark on how to correctly fix this problem. More information is definitely needed.

If I take a peek in your Windows, to fix a problem, does that make me a "Peeping Tom"? Hmmmmmmmmmm

 

[tatika]

hi:
I know my description is a little too broad, but what I really need to do is to use check boxes that mark equipment required as well as its quantity.
The use for this information to store data into a blank table that I later plan to use to create reports, such as figuring out how many equiments where used within a specific time period and the users that used it.
I really would like to use check boxes (yes/no)and not a lookup field...
thanks

 

[assets]

Yes I think i know what you mean. The check box runs a query on the item eg microphone. I use a combo box on a form to select the item and once selected you can display a list of all item selected eg microphones.