Jump to content

relating to external file reference


cmulgrum

This topic is 6114 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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...

Link to comment
Share on other sites

This topic is 6114 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.