>I used the form builder to create my form from a table in VFP 3.
>Once the form is executed, all the fields will get its individual data
>from the table(eg Product.dbf). The ControlSource property will have
>eg. Product.Pcode(ie Product Code field) and so on.....
>

Instead of form builder try wizard

>I could create the record navifation buttons to skip Next/Prior/Top/Bottom.
>
>1) I wonder how should I go about appending a new record? As the key field
>Product.Pcode contain an existing Product Code key field that will voilate
>the uniqueness of the key field once the Append command is issue.
>

start the buffering on table when the user appends record/fill value check the existense, if exist issue =tablerev(.t.) and go into edit mode otherwise append records

>2) How could I clear all the label fields on the form to set to 'blank'?
>

I guess you are talking about fields, if so issue appe blank.


>3) I wonder which will be the best way to create a table maintenance
>module.
> That includes Add new record, Edit existing record and Delete unwanted
>record.
> I still couldn't figure out which is the easiest and having full
>control method?
>
>Please advise, any suggestion are welcome. Thank you.

Hope this helps !!