Search results

We are a manufacturing company. I and two more people will be using this database. We order supplies for my company this is to generate a purchase order for my boss to approve and then we send it to the supplier of that specific material as needed. We add items over time and change prices. Also...

Sorry, I hadn't seen your post. okay I did the following for my tables: tblSuppliers -Supplier ID (PK) -Supplier Name -Supplier Address -Supplier Phone # tblPurchases -Purchase ID (PK) -Purchase Date -PurchaseOrder # -Supplier ID (FK) tblMaterials -material ID (PK) -Material Name -Material...

Hello, I want to create a database on access. This database would be a table with list of materials with their qty, id, description, uom, and unit price. These materials are materials my company buys very often. So my plan is to then create a searchable list for this materials. I have achieved...

do you by any chance know how I could redesign to fit all my needs?

i am able to select multiple items however, both items need to be on the same screen at the same time...if i search on an item, click on it, and then search for another item and click on it and then click on the "throw all items" button it only throws the second selection,not the first.

can you help me properly design my tables

there's no difference

everything works great. however, the list only lets me select two if i do not search for the materials. in this sample table there are only 3 materials so they all considerably fit in the selection box all at the same time. however, keep in mind that there is over 200 materials that are going to...

I looked at them but keep in mind I know absolutely nothing about programming so to me I was just reading Chinese.

i added the sample data

I have attached what my template for PO is

Okay, I'll try to explain as best as I can from the beginning. In my business we make purchase orders of, for example gloves, and I wanted to, instead of searching one by one for that exact material, create a database where I can just search for the material and when I select that material it...

so there's no solution to that?

Im confused on what exactly you mean. It's just POs for necessary inventory materials, nothing big.

this works great, thank you.. Now, what if I want to add multiple items to the same PO?

I am using the exact version you sent me. All I added was the command button on list 1 to search of materials because it is going to be a long list. However, when I try to search for materials only company appears and doesn't transfer to list 2. Im sorry if I'm frustrating you I just really need...

This worked perfectly fine until I inserted a Command button above list 1 to search for keywords. If i click on the list for a material it still sends it to the second list. However, when i search of the material and click the search button the company appears instead of the material and when i...

I am aiming to make Purchase Orders easier. On the first listbox I have the materials with the price, company, and ID. On the second list box I have a template of the Purchase Order of the company. What i want is for me to select the material from my first listbox and that automatically sends...

that opens the second form however it does not show item selected on the second form.

It tells me my forms and lists can not be found. I am using version 2016.