>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 !!
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only