3 replies to this topic

[PURE-DNJ]

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

[Videoflicks2004]

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

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

[PURE-DNJ]

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?

[Videoflicks2004]

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?

Hello,

Perhaps if you tell me more about your goal with the filter function?

Exactly what is it that you want to compare between the two tables?

The easiest tool for a newbie is RR . There are a lot of reports that will make the purchase worth while.

Cheers,

Videoflicks2004