gottdestodes
New member
- Local time
- Today, 16:59
- Joined
- Dec 7, 2020
- Messages
- 3
I am new to Microsoft Access and I am learning as I go. I am currently using Office 2016 Pro and the database has been split into a front end and back end. The company that I work for is a small machine shop with a simple type of database. I have this form
Part_Number and I believe it was setup via the form wizard. I have this other table labeled MATERIAL_ORDER and inside MATERIAL_ORDER I have a field MATERIAL_TYPE that i would like to add the the Part_Number form.
When I put it in design Mode and then click on Add existing fields and I then show all table. I then choose the section I want to be added, I then get prompted to specify the relationship. This is where it gets tricky for me. Each table has a Part number section so I tried to create the relationship between both the part numbers. Then I get confused form there to which option to choose
I chose the first option. Now the field will show with the information I want. Now when I use the drop down for Find a part and I choose a part some parts will show up and populate and others won't do anything. Now if I remove all these new settings everything works again.
I hope someone here can help me out with this. I have been stuck on this for the last couple of weeks now and my company would really like to get this field on the database. So any help would be great. I do understand a few terms here and there but like I am new to this. I know I must be leaving certain things out that might help anyone with resolving this, so if there is anything I haven't included please ask and I should be able to add to this post.
Thank you in advance.
-Mark
Part_Number and I believe it was setup via the form wizard. I have this other table labeled MATERIAL_ORDER and inside MATERIAL_ORDER I have a field MATERIAL_TYPE that i would like to add the the Part_Number form.
When I put it in design Mode and then click on Add existing fields and I then show all table. I then choose the section I want to be added, I then get prompted to specify the relationship. This is where it gets tricky for me. Each table has a Part number section so I tried to create the relationship between both the part numbers. Then I get confused form there to which option to choose
I chose the first option. Now the field will show with the information I want. Now when I use the drop down for Find a part and I choose a part some parts will show up and populate and others won't do anything. Now if I remove all these new settings everything works again.
I hope someone here can help me out with this. I have been stuck on this for the last couple of weeks now and my company would really like to get this field on the database. So any help would be great. I do understand a few terms here and there but like I am new to this. I know I must be leaving certain things out that might help anyone with resolving this, so if there is anything I haven't included please ask and I should be able to add to this post.
Thank you in advance.
-Mark