Jump to content

Related files opening automatic


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

Recommended Posts

Hello, i'm somewhat new to relational design. I just got finished converting my flat database into a relational database

with four files, and yesterday I installed it on our small network. There are three Macs all running FMP

6.0v3, peer to peer networking.

The problem I ran into is that some of the related files were not automatically opening when a client was

doing an activity that required them. The primary files i 'Orders', and the major related file is 'Line Items'.

Line Items opens automatically, as desired, since the initial script requires it.

Occasionally the user makes a new Line Item which requires a price markup. If this is so, Line Items is supposed

to look up a value from related file Markup Table. At first, Markup Table was only referred to by Line Items, and this wasn't working on the

client side whatsoever. I added a script step when one of these special line items is created that will cause

the Orders file to set a global field to the value of a global within Markup Table, just to force Orders to open it.

This worked, but only if the Markup Table was open on the host machine before a client attempted it.

My solution was a new startup script which will force all the related files to open by reading in a global value friom them, and this works, however

two of the related files are rarely used, and it seems a waste of resources to have them open for each session.

Is there something I am doing incorrectly?

Link to comment
Share on other sites

This topic is 7811 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.