PDA

View Full Version : Two same fields in a form Print & Save command?



aligahk06
04-22-2010, 03:36 AM
DEAR ALL,
I have a form generated from table fields.
There are two fields that is same,say PO number.
I want if i update PO number at one place then the same PO number field automatically updated .
No need to enter two times PO number at two different field.

Moreover, I want a print command i and a save command in my form.
Any Help?



Rgds,
Aligahk06

OBP
04-22-2010, 04:43 AM
Aligahk, can I ask why you are duplicating the data, it is not good database design to do so.

CreganTur
04-22-2010, 06:52 AM
I agree with OBP- with correct Relational Database modeling you should never duplicate data unless you have a really, REALLY good reason to do so. If you're stuck working on someone else's database and can't correct the database model, then let us know a little more about the problem and we'll try to help.