I am a beginner access user and am trying to develop a db for all of our equipment as well as all of our spare parts for that equipment.
I have attached 2 files with screen shots of the relationships page (attach 1). I am trying to create a relationship from the tblparts PartsID to the tblequipmentlist Parts. I made sure the properties on the Parts field are set to a number. I also created it as a lookup to the tblparts table. When I try and create the relationship, a new box appears named tblparts 1 (attach 2). What is that? And it also creates it as a 1 - 1 relationship.
Each piece of equipment has multiple spare parts. Am I setting this up backwards?
Ultimately when I open the frmequip, I would like the list of parts to show for that particular piece of equipment. Similarly to when I open my frmManufacturer it shows all of that manufacturers equipment (attach 3)
This is another question:
The maintenance guys that are responsible for getting me the data to populate this db are in the field. In order to keep from getting 100 pieces of scrap paper with missing details, I designed the "forms" for them to use to give me what I need in the order I need it. Well, as I have learned, you can't print the forms in access. How do I take one of my blank forms and export it so I can give it to them to use when they collect the equipment/ part information? I tried exporting it to Word - that didn't work. I tried creating a report, but all that gives me is a data table populated with all the pieces of equipment. All I want is a blank form in each category so I get the "all" information in the correct order so it is easier to enter it into the db.
Would appreciate any help you can give.
Catherine