>Is it always best to work with views instead of the tables themselves?
>(I'm very new to VFP) and am having a little trouble. If I change the value in one column of a grid, it correctly updates the table it came from, but if I delete the record it doesn't and if I try to insert a record it brings up an 'Add Record' dialog and forces an 'add record to child only'. Not sure what's going on. I think I have the Integrity of the tables in the DBC set correctly.
Do you have SET DELETED ON, as for adding records whats your "add" code look like? I usually do something like:
m.KeyField = PARENTTABLE.KeyField
INSERT INTO CHILDTABLE (CHILDTABLE.KeyField) VALUES (m.KeyField)
HTH
Thanks
Jon
Non-MVP Non-MCP Non-MCSE
Visual FoxPro, What else is there?