John Baird
Coatesville, Pennsylvania, United States
General information
Title:
1-M-M Grid problem. Please Help!
Help!
I am in the midst of developing a rather large C/S application using remote
views. On one form, I have placed a pageframe with 4 pages. Page 4
contains another pageframe with 6 pages. I am using Access 7.0 as the back
end for development with 32bit ODBC driver. The flow is this:
1st pageframe has parent Field Serive Repair Record with/pertinent data on
pages 1-3. Page 4 contains another pageframe with the 1-M child: Request
for service on page 1 and the other 5 tabs are 1:M children of the Request
for service table.
What we have in essence is 1:M:M.
The problem: If I update the request for service grid on page 1 of the 2nd
pageframe, and use tableupdate() or tableupdate(.t.) the update fails with
an ODBC error. I can tablerevert() with no problem.
When I move the grid to page 4 of the 1st pageframe and deleted the 2nd
pageframe all works well.
Any clues?
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