Tech Support Guy banner
  • Please post in our Community Feedback thread for help with the new forum software! If you are having trouble logging in, please Contact Us for assistance.
Status
Not open for further replies.
1 - 7 of 7 Posts

·
Registered
Joined
·
4 Posts
Discussion Starter · #1 ·
Hi Guys

Hi am trying to duplicate the entire content of a table into the same table but adding the prefix "A_" in front of the new data. With this i will have the same data twice but one with the "A-" all in the same table.

Can any body help me?

Thanks
 

·
Registered
Joined
·
4 Posts
Discussion Starter · #3 ·
I need to do this because we need to control the inventory of the different shops and the software we are using does not allow us to do so. By add the prefix "A-" in front we can control two diffrent inventory with the same software.

Thanks for the reply
 

·
Registered
Joined
·
19,896 Posts
smarier, you do not need to duplicate the stock to cover 2 shops, you use a Many to Many table that relates the stock to the Shop and contains the Quantity for that shop. ie
Inventory table
ID 1 Sugar 1KG Bag
ID 2 Tea 1KG box

Shops
ID 1 shop 1
ID 2 shop 2

Linking Table
Shop ID 1 - Stock ID 1 - Quantity 100
Shop ID 2 - Stock ID 1 - Quantity 20
Shop ID 1 - Stock ID 2 -Quantity 25
Shop ID 2 - Stock ID 2 -Quantity 1
 
1 - 7 of 7 Posts
Status
Not open for further replies.
Top