Hi Darren,

Once you create the Mycust database you need to use DBUWIN to create an index.

1. Open your new database in DBUWIN
2. Select TABLE/CREATE INDEX
3. Type the following exactly: "CUSTNUM"

Now open R & R report writer and create a new report with CUST.dbf related to MYCUST via CUSTNUM index.

I have a sample report to attach to this post but the forum generated the following error:

Upload failed. Please ask the administrator to ensure the uploads directory is writeable

Oh i see,

We dont have R&R writer and was hoping to do this directly in DBUWIN, i am able to create an index ect, but really wanted to see if I could filter the cust table based on the mycust table. Do you think this is possible?

Hi, I am trying to filter my customer table (cust.dbf) against a table i created called mycust.dbf.

I tried the following equation but it only filters with one result.

cust.custnum = mycust.custnum

can anyone advise the correct equation?

Darren