Hi!
i have a local view with 2 tables in "one-to-many" relationship: people and ticket.ID is the primary key of "people" table (integer AutoInc type;i'm using VFP 8) and foreign key in "ticket" table.
The problem occurs when i wish to add a new record.The update of the tables is made corectly in the case of "people" table (the new record has an incremented ID),but when i'm looking in the "ticket" table the foreign key has the value "0".Does anybody know how can i update the foreign key with the right value?
thank you!
i have a local view with 2 tables in "one-to-many" relationship: people and ticket.ID is the primary key of "people" table (integer AutoInc type;i'm using VFP 8) and foreign key in "ticket" table.
The problem occurs when i wish to add a new record.The update of the tables is made corectly in the case of "people" table (the new record has an incremented ID),but when i'm looking in the "ticket" table the foreign key has the value "0".Does anybody know how can i update the foreign key with the right value?
thank you!
