Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with multi one-many pageframe, w/ Codebook
Message
From
21/04/1997 12:37:54
Andrew Gray
Petrolink Services Ltd
Aberdeen, United Kingdom
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00029095
Message ID:
00029104
Views:
26
>Hello,
> I need help with coding a pageframe using three tables. A quick run down: The tables are called: members, accounts and contribs. Accounts is one to many related to members, and members is one to many related to contribs. Accounts contains address info for members. If two members live at the same house they share the same account. Also each member can have any number of contributions in the contribs table. Essentially what I am trying to do is have the info from each database on a seperate page of a pageframe.
>
>I am using Codebook and have tried to use Edward Leafe's eBizObj, with some success. I still have a few problems.
>
>1) I want the nav buttons to skip through the members table, not the true parent table: accounts. It does this now, but the accounts table stays on the first record.
>
>2) The contribs page of the pageframe contains a grid of all contributions from the current member. When I edit a value in that grid and then click on any nav button, it doesn't give me the 'Values have changed, do you wish to save?' message.
>
>I have pulled the accounts and contribs data using local views and the members data direct from the table.
>
>Any ideas would be greatly appreciated.
>Thanks in advance,
>-Jonathan Graham

Following yr order above.
1) Can you make Accounts a child of Members, at least as far as the form hierarchy is concerned? it looks more like a nonstandard 1-1 relation this way.

2) Check out the cBizObjForm.WriteBuffer() method (it might be in cBizObject). This checks if the active control is a grid and doesn't flush changes if it is. TABbing to a new column means that the changes do get noticed so perhaps a KEYBOARD or similar in that method.

Where can I get hold of this eBizObj thingy ?

Good luck
Andy.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform