Hello All
I have a form created at the set level. There are 7 tables in the set. On the form I have 7 tabs, one tab for each table. There is a subform for each table, the 1st tab being the Primary table (Customers).
On the 2nd tab I also have a browse object set to read only. This is a list of all the child records for a particular customer (Parts).
So, on the 2nd tab I have a summary of the Customer record (readonly), a subform so that I can enter/change/delete Parts records, and a browse which shows ALL the parts for the Customer.
All is fine except for one thing. When I go to edit a record (in the subform), and I modify 1 field and save, everything is OK. If I modify more than 1 field the record changes to another record. If I cancel the changes at this point and edit again everything works fine until I select another Customer.
If I remove the browse from the form everything works as it should.
An observation I have made is that when I click the field (first time) to edit, the egg-timer pops up for a second or 2.
Has anyone any thoughts as to what is happening and a workaround. Hopefully I've given enough info and explained the situation sufficiently.
This is an A5v4.5 app which I'm porting to A5V5 (1 of 10 I'm currently working on).
For security reasons I can't give you a sample of the DB.
There are 34k Customers & 170K Child Records.
Chris
I have a form created at the set level. There are 7 tables in the set. On the form I have 7 tabs, one tab for each table. There is a subform for each table, the 1st tab being the Primary table (Customers).
On the 2nd tab I also have a browse object set to read only. This is a list of all the child records for a particular customer (Parts).
So, on the 2nd tab I have a summary of the Customer record (readonly), a subform so that I can enter/change/delete Parts records, and a browse which shows ALL the parts for the Customer.
All is fine except for one thing. When I go to edit a record (in the subform), and I modify 1 field and save, everything is OK. If I modify more than 1 field the record changes to another record. If I cancel the changes at this point and edit again everything works fine until I select another Customer.
If I remove the browse from the form everything works as it should.
An observation I have made is that when I click the field (first time) to edit, the egg-timer pops up for a second or 2.
Has anyone any thoughts as to what is happening and a workaround. Hopefully I've given enough info and explained the situation sufficiently.
This is an A5v4.5 app which I'm porting to A5V5 (1 of 10 I'm currently working on).
For security reasons I can't give you a sample of the DB.
There are 34k Customers & 170K Child Records.
Chris
Comment