Acces Inventory Price change issue

**pervezahmed** · 02-17-2013, 11:50 PM

Dear sir

I have created a database called SMCC Products database. This is specially created for the Perishable items where the price change daily,
I want a form where i will take a circular and there will be a bar code field. i will input barcode and the current price and details will show and i will input new price in the new price field. After input new price the products details will change. But i want that in one circular id i will change multiple products MRP, TP, GP%, with the barcode field.
I have a table and also a form called Products and the fields are,
Primary key = bar code
Category
Description
MRP (retail price unit)
TP (Cost price unit)
GP % (gross Profit)
Etc

I have also a table Circular ( to change the price when i want to
where Circular id is the primary, and circular date and barcode,
I am in fix now how to make relationship and the new form of Price Change.....
Please help me....

Pervez ahmed

**burrina** · 02-23-2013, 10:29 PM

The rule is to use a primary key on the first table and a fake key in the second and link them accordingly.
If your main table is keys with a keyid pk and the second table is chains with a pk of chainsid but also a fk of keyid so they can link together!
Hope this helps.

**pervezahmed** · 02-24-2013, 10:48 PM

Dear sir,
Thanks for your valuable reply....I have made a fake table where 1. bar code id Pk field
2. Description
3. New Tp
4. New MRP
5. New GP
So am i needed to add circular id field in this table or i have to do anything else please let me know the details of the relationship.......
Thank you for your understanding with this matter.
Pervez Ahmed

**burrina** · 02-24-2013, 10:53 PM

Add both tables to your query and any criteria and your good to go.

**pervezahmed** · 03-05-2013, 07:15 AM

Dear sir,
Thanks for your advise. I have link the Real barcode and the fake barcode From both table. And made a query for the form by adding Barcode, New TP, New MRP, New GP from fake table, and Description TP (means old), MRP (means old), GP (means old) from the main table. thats done successfully.
In fact when i open the form and put the barcode in the field the data shows Old details, and i put the New TP , NEW MRP, and save that

But the thing is that after close the form and go to the main form. I found that the product price i changed shown the old price and GP%, Not the new Price and GP,
I am in fix now. Am i doing wrong......If so then how to solve this problem......
Let me know as soon as possible.
Thank you sir for your understanding about this matter and your utmost advice,,
Pervez Ahmed...

**burrina** · 03-05-2013, 12:20 PM

Is your form based on a query or a table? A query will update itself, a table needs added code to do this. Can you post any screenshots of what you are trying to do? Do you have a subform on a main form? When you test the query with new data, does it perform as expected? View table before and after for results!

**pervezahmed** · 03-05-2013, 11:14 PM

Dear sir,
Thanks for your understanding....and the eagerness......I have attached the problem i am facing..Please see that and give me the solution.......
I want that after price change,...The Product price will be replaced with the new Price that i put in the new price entry....
Thank you once again.......

Pervez Ahmed