Razzak,
Thank you for the reply.
1) There are 5 tables, each on its own tab. Customer table is the
driving table <PK> CustID. All other tables are FK to Customer with
CustID in it.
This form started as a 7.5 then 7.6. then 9.1 form.
2) Many to Many
3) Only the needed 5 tables are listed in the Table Properties.
The enhanced grid displays a temporary table (RETURNGrid) created by the
forms On Before Start EEP (see below). I simply wanted a tab with a grid
to show a subset of rows with that CustID, not all the rows. When the
user closes the form, the temp table is then dropped.
--On Before Start EEP
PROJECT TEMPORARY RETURNGrid +
FROM EFT +
USING CustID, EFTID, EFTCkNum, EFTDebitAmount, EFTAmount, +
EFTDateReturned, EFTReturnCode, EFTDatePaid, +
EFTPaidCode, EFTPaidAmount, EFTPaidCheck, EFTPaidFee +
WHERE CustID = .vCustID +
AND EFTDateReturned IS NOT NULL
This is what calls the form.
EDIT USING CustView_WIP +
ARRANGE EFT by EFTCkNum DESC, +
ARRANGE ACTIVITY by ACTDate DESC, ACTTime DESC, +
ARRANGE RETURNGrid by EFTID DESC, +
ARRANGE PAYMENT by PaymentDate DESC, +
ARRANGE WITHDRAWAL by WITCkNum DESC +
WHERE (CustID = .vCustID) MDI as fCustView
I studied your recent Tip of the day on Filter Parameters which is great
and I will try that next. I don't get how to set a column filter to 'IS
NULL' or 'IS NOT NULL' but I have not tried it yet.
I would like to get the above code working anyway just because I don't
want to be defeated by it but I will try to see what the filter
parameter can offer.
Thanks Again!
Rbase Rocks! Always did!
Thom
On 5/3/2011 12:52 PM, A. Razzak Memon wrote:
At 12:13 PM 5/3/2011, Thomas Cimicato wrote:
Using Form Designer (RB 9.1) when I place an enhanced DB Grid on a Tab,
there is a message under the grid <No Data To Display>. There is plenty
of data in the table of the DB grid. When the form is run, the DB Grid
shows all the rows in a flash then disappears to only show the last row
of the table. The DB grid table is the many side of the driving Customer
table with a FK reference of CustID to the driving Customer Table.
Thom,
A few questions and a suggestion:
01. How many tables are associated with this particular form?
Form Designer | Main Menu | Add or Remove Tables ...
Notice the Panel with Main Table and Slave Tables
02. What is the selected option for Table Relations?
One to Many or Many to Many
[F11] | Form Properties | Table Relations
Now a suggestion:
01. While adding table(s) to the list, only include the table(s)
that are actually being used in this form.
Hope that provides you with some blue's clues ...
If all else fails, contact me and I will show you some basic steps
to setup Enhanced DB Grid using Crossloop.
Good luck!
Very Best R:egards,
Razzak.
