Account names with multiple files...

[Simon K]

Hello again,

I am not sure that this is the correct forum but I am new so would appreciate redirection if necessary.

This post is a little long but I would appreciate any insight you guys can give on what is going on.

I am writing a business system application for a project based company.

I have separated the data into BusSysData.FP7 and the layouts etc into BusSys.FP7.

I have a table called "activities". I have another table called timesheets. An activity can have one or more timesheet entries. The timesheet requires a peopleID field to be completed that stores a foreign key to the "people" table as a number.

One activity type is receiving a telephone call in and I want to create an automatic entry into the timesheets table - all ok so far.

I have set up a table called users to store the account name (to match the FM account name) and the related PeopleID value.

I have linked the activity table (using an auto entered "createdby" field which stores account name) to the users table: account name field.

After the activity record is committed I have a script that creates the timesheet entry - in particular one line of the scrit calculates the people id by looking up the correct people id from the users table using the relationship above.

This script could be triggered from a button but at the moment i am using the doscript event from FM butler to fire it off on committing the record - which is much slicker from the users point of view.

Mostly this is working fine. Except as follows (as nearly as I can tell)

If the data file is closed no problems at all.

If the data file is open and logged in as one of my created users it seems to be fine.

If the data file is open and logged in as admin the people id field in the timesheet just has a question mark in it.

Completely mystified by this one. I am really concerned about the future - the app needs to be rolled out to about 10 users - at the moment i am just using single user to develop a prototype.

I am very new to this but would appreciate any help at all.

Cheers and beers

Simon

PS Forum is great.

thanks

[Simon K]

Addendum to above...

["If the data file is open and logged in as one of my created users it seems to be fine".]

Its not fine at all!

I have tried looking at it a bit more - it seems

If the data file is open then the account name used is the one of the data file - how is that going to work with multiple users or on server?

Thanks

Edited February 4, 2007 by Guest

[Simon K]

I think this was all caused by having the data file open (by different accounts) which I don't believe will happen in multi user mode etc

Thanks for looking