Relating More Than 2 Linked Databases in a Form

[chris5695]

I have 3 tables: "Contract", "Task Order" and "TO Amendments". Contract has a one to many link with Task Order and Task Order has a one to many link with
TO Amendments.

On a Form tied to Contract, I can create a table to display data from Task Order. I want this table to also show a sum of data from TO Amendments, but can't; TO Amendments is not selectable when I try to define the table on the form. Why not and how can I display data from a table that is indirectly linked?Thanks, Chris

 

[footpad]

Chris,

If by table, you mean table frame, you're running into a limitation of table frames.

While you can show multiple tables in table frames, you can only do so if the additional tables are linked to the first as single valued links, e.g. 1->1 or M->1.

Use a separate table frame (or a crosstab) for your summaries.

Hope this helps...

-- Lance

 

[chris5695]

Thanks, Lance. I guess a separate table frame or crosstab would work if I could get the two to scroll together so that they appear as one to the user. Any ideas on that one?

 

[footpad]

Chris,

You might consider adding code to the action event that detects Move, Data, and Select actions in the table frame and then sychronize the crosstab accordingly.

I'm pretty sure there was a recent conversation along these lines on Corel's newsgroups that discussed this. Go to

http://www.deja.com/usenet

and then use their Power Search to search *paradox* groups for "table frame scroll bar" in the complete archive. you'll need to wade through a few messages, but I think there were some samples that would be relevant.

Hope this helps...

-- Lance

 

[chris5695]

Lance - Thanks. I found another work around that seems to involve less hassle than that involved with scrolling different tables/crosstabs together. On the form, I've put the data from all 3 databases in nested Multi-Record Objects. These scroll together with no code. I'm still having problems with calculated fields which require the use of all three databases but am trying to work through it. Any thoughts on that? Chris

 

[footpad]

Chris,

Depends on the calculation and what you're trying to do. Can you elaborate?


-- Lance