Hi, and Thanks again for the support from this forum.<br><br>I have 4 table database, each table assigned to a region of the country. each table are similar in field names, which are "PO Number" "Name" "Date Received" and "Status" ( these are the values more important). See, all pos in the 4 tables have a status of "IN TRANSIT" and field "Date Received" is blank. what I really wanna do is be able to update the records where I can change status to "DELIVERED" and then enter the date delivered in "Date Received". I could do that manually, but since every po in the tables are unique, I would have to look for them. So what I would like ( if possible) to code a form where I will have 3 textboxes, PO#, Status and Date, so I would enter the PO number, Access would look for that PO number and find it on the table. Then, I could just change the status to "Delivered" and enter the delivered date on the other 2 textboxes!!! If the Po is not there, access would return some sort of info saying "PO not found". I am really not sure if can be done, some people have suggested me to use the find feature, but that does not seem suitable...Thanks for taking ur time to read all this and I hope to be able to do this!!!!!! Thanks!!!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ADDING UPDATE CAPABILITY
- Thread starter HerickP
- Start date
I would put all of your 4 tables into 1<br>and add a new field to that one table that has Region in it.<br>then you only have one table to worry about and not 4.<br><br>It could be done easily by and append query.<br>First add the region field to each of your 4 tables.<br>Then, Open the first table, Lets call it Region 1, in the Region field (column) put 1 in it for every record. this can be done quickly with the find and replace.<br>Open the second table and do the same for region 2 and so on.<br>Then when you append the 4 tables together they will already have their specific regions and not get mixed up.<br><br>OK this is the best way to use your data <br>Then when you want reports by all regions you are only looking at ONE table again.<br>Use the "Group by" in your report to get a particular region. <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.
- Thread starter
- #3
This will only gather all the data into one table. Now, what about the part where I can update the data, sor of, entering a PO in a texbox, then , have access to find it, and if so, give me the chance to update the STATUS and DATE without having to touch the table, just using a form??
- Status
Similar threads
- Locked
- Question
- Locked
- Question