OverSight
New member
- Local time
- Today, 13:56
- Joined
- Jul 29, 2021
- Messages
- 18
I am brand new at using MS Access so I have pretty much zero knowledge of what I'm doing. I have been reading online best I can but just not following or haven't found something that helps me. Apologies if I'm posting in the wrong thread. I will try my best to explain what I'm looking to do.
Situation:
I'm trying to create a database that will be used as a vendor lookup database. In the database users will view/add/modify Vendors. For each Vendor record I am using a form to display the vendor information details.
Along with the Vendor information on this form, I would like to have a section or separate tab that shows a sub form containing a list of products the vendor carries.
In the sub form, I want the user to select from a predefined list of products that I've populated in another table that contains (the commodity code, short description and long description). Once they select this, I want them to be able to add the actual item they have purchased which would be ad hoc.
For example:
User selects, searches from the list of pre populated commodities, (Shown in Blue Font here), pulled from a pre populated table, then will add the actual item they bought under the Goods Supplied Field (Shown in Red Font):
Commodity Code: Commodity Short Description: Commodity Long Description: Goods Supplied:
7510 Office Supplies Office Supplies Pen
I would like this to be unique to each vendor record. I think I will need to have some relationships and I'm guessing some additional tables to do this. I'm willing to attach a sample of what I have done so far. I have been piecing things together using samples from other databases I have found along the way. I'm sure I'm doing things completely wrong so I'm totally willing to accept any advice and critiques as I hope to learn from my mistakes. Thank you in advance.
Situation:
I'm trying to create a database that will be used as a vendor lookup database. In the database users will view/add/modify Vendors. For each Vendor record I am using a form to display the vendor information details.
Along with the Vendor information on this form, I would like to have a section or separate tab that shows a sub form containing a list of products the vendor carries.
In the sub form, I want the user to select from a predefined list of products that I've populated in another table that contains (the commodity code, short description and long description). Once they select this, I want them to be able to add the actual item they have purchased which would be ad hoc.
For example:
User selects, searches from the list of pre populated commodities, (Shown in Blue Font here), pulled from a pre populated table, then will add the actual item they bought under the Goods Supplied Field (Shown in Red Font):
Commodity Code: Commodity Short Description: Commodity Long Description: Goods Supplied:
7510 Office Supplies Office Supplies Pen
I would like this to be unique to each vendor record. I think I will need to have some relationships and I'm guessing some additional tables to do this. I'm willing to attach a sample of what I have done so far. I have been piecing things together using samples from other databases I have found along the way. I'm sure I'm doing things completely wrong so I'm totally willing to accept any advice and critiques as I hope to learn from my mistakes. Thank you in advance.
Attachments
Last edited: