General information
Category:
Coding, syntax & commands
Title:
AllowAddNew=.T. in 1-many Form. How to coordinate?
I don't like the idea of troubling the user to add child record shown in the samples. Therefore, I use AllowAddNew=.T. in my child grid. To maintain the 1-many relationship, I use a surrogated key. My question is: what is the best time to update the surrogated key to the child table so that the 1-many relationship is kept. I have to update the key some time after VFP automatically append a record, right?
I also read that we can use a denormalize view for the 1-many form, ie. an updateable view of master-detail. Is that a better way? Any disadvantage?
Next
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