relating to external file reference

[cmulgrum]

I have a database running on fm server 8.5. I want to create a local fm 8.5 db that calculates values based on field values on the server side.

I've created a local file and created a reference to the server side table. Then I created a relationship between the server side field (itemnumber) and the local field (itemnumber).

The purpose is reporting only and I don't want to modify the server side. The report output will be the creation date of the server side record and left(itemnumber,10)...itemnumber being the field on the server side database.

I appreciate your suggestions.

Craig

[Inky Phil]

I might be missing something here but I am not too sure what you want to know.

Phil

[cmulgrum]

Serverside Database table (ArtTable)has Itemnumber and CreationDate.

In a local FM file, I want a report that shows me Itemnumbers for a creationdate range. Additional fields would break up Itemnumber into 3 fields:

Base:left most 10 characters.

Color: mid(11,3)

Size: right most 2 characters.

I don't want to modify the app on the server side...only want to refer to the server tables...