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    
post Dec 7 2017, 06:21 AM

Posts: 260
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
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: 8
Go to the top of the page

Posts in this topic

Custom Search

RSSSearch   Top   Lo-Fi    17th November 2018 - 04:31 PM