UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Updating Records In Main Database?, Access 2010    
 
   
ciapul12
post Dec 7 2017, 06:21 AM
Post#1



Posts: 225
Joined: 7-June 14



Hi All
I desperately need help please.
I reckon for some of you it’s simple but I’ve been trying to learn about the relationships and still stack where I was 2 weeks ago…
What I need is, I have 3 tables where I store the information, 1 table for suppliers/growers, another one for varieties and 3rd one for all different products. Then there’s main table which user populate by using a simple form called Prodlive1.
Everything works but when I change some details in one of those 3 earlier mentioned tables, the records in Prodlive1 table do not update…
Real data base contains thousands of records so for example if I have 200 records referring to a specific product in Prodlive1 table and I have changed the price in pack type table for that product I then need to update manually 200 records… The same things go for other information from those 3 sub tables…

Can you please help me? I’m losing my mind :-(

I’ve attached my database with sample data..

Best Regards
Dan
This post has been edited by ciapul12: Dec 7 2017, 06:21 AM
Attached File(s)
Attached File  Prod_Live_FE__2_.zip ( 1.24MB )Number of downloads: 5
 
Go to the top of the page
 

Posts in this topic



Custom Search
RSSSearch   Top   Lo-Fi    10th December 2017 - 11:13 PM