Sarahbyrne3
New member
- Local time
- Today, 22:01
- Joined
- Dec 13, 2021
- Messages
- 19
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
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