Solved Add existing record to new table

[Sarahbyrne3]

Hi everyone,

I have created a database that has materials that we order on a regular basis. The idea is for our site team to search the items they want to order, add them to a order request and then send it to our buyers. Our buyers will then take this, pull the records from the O.R and put it into a P.O.

I have a filter box that once an item is selected goes into a list below, i want an 'Add to O.R' button that will take that selected info and put it into a table (separate table not related and already created) using a O.R number (human created) that will then push that information to a report but only show the information on that O.R number.

e.g. John Doe wants to order x, y & z for project B1008 on O.R number OR0001.

It may be that i need a 'search records' pop up on the O.R record to get all the same order on the one record? But the main thing for now is the add button that is driving me mad as it should be very very simple. No 'For Dummies' book is helping and no amount of research is letting this sink in. Im probably over complicating this more than i should.

Please send help

 

[June7]

If an order can have multiple materials, then OrderRequests should be split to two tables: OrderRequests, OrderMaterials. Then build a form/subform arrangement with main form bound to Orders and subform bound to OrderMaterials with a combobox or listbox to select material.

Where is the 'human created' order number?

 

[jdraw]

@Sarahbyrne3

I think your current data model/relationships does not fully address your business. You may find some helpful info at this model at Barry Williams' site.
I would also recommend you review the stump this model approach to assist with design.

 

[arnelgp]

you can check this demo.
open form frm_order.

 

[Sarahbyrne3]

you can check this demo.
open form frm_order.

This works perfectly thank you very much

 

[Sarahbyrne3]

@arnelgp Is there any way to make the search bar search more than one word. E.g. clip 50 ... this would then bring up the 50mm clip. I'm trying to narrow down this search function a bit.

Thank you for all your help btw, its been amazing

 

[arnelgp]

here you test frm_Order again.
on the search form, you can separate each
"search words" with a space.

 

[Sarahbyrne3]

Thank you again. How do i add some more information to the tbl_ORDetail? Ive added new fields so that i can pull the information to the reports but its not picking up the information from the frm_Order. Also if i change the naming format on the tables, forms and queries in both access panel and the VBA will it mess anything up?

Sorry to be a pain and thank you again for all your help. I really do appreciate it

 

[arnelgp]

you upload your latest db.

 

[Sarahbyrne3]

Attached and thank you so much. Its pretty much the same as the one youve sent me.

 

[arnelgp]

here test your Order form (check the button for Print Preview).

 

[Sarahbyrne3]

Yep thats spot on, thank you again.

 

[Sarahbyrne3]

The order report is showing all records on one page.... how do i get it so it only shows one order at a time? Again i am so sorry to be a pain, im slowly learning

 

[arnelgp]

Print it on the order form.

 

[Sarahbyrne3]

Sorry yes its working from there. I couldnt get the print preview button to work but it seems to be working now