AnsweredAssumed Answered

help duplicating portal data

Question asked by Pichi on Jan 18, 2010
Latest reply on Jan 18, 2010 by Pichi

Title

help duplicating portal data

Post

Hi!

 

i just finished my fm invoice program, but now i have 2 issues that i need to solved, someone can help me?, before i need to describe my fm db:

I have 1 file, name MASTER, this file have some tables those are:

 

1- master

2- lineItems

3- Budget

4- Job Order

5- Invoice

 

and i have others field those are related to my master file

file: customers

file: products

file: extras

 

All data from all my files are related to my MASTER file and i can made my invoices, budget, jor order, son on..., but i have 2 issues that i need to solved URGENT!

 

1- duplicate data from my table: when i duplicate my master table to create a new one and don't have to copy all data I only can copy some related data, but the LineItem dosen't copy to my new record how can i duplicate all my data ?

 

2- the lineItem is related to my products, this work great but if i need to modificate 1 field from my master table all items who has the same products change, it's posible to change just one and all the other identical keep the original data without create a new products each time that i need to do that?

thanks

 

Outcomes