Jump to content
Sign in to follow this  
laker_42

Need some help

Recommended Posts

I posted this question earlier and I thought I had come up with a solution for it but it isn't working. So I will try to explain what I am doing.

We have 8 different dbs with one of them being an index db that only contains links to the other dbs. The 8 dbs contain different forms that our Human Resources uses (Ex. Termination, Promotions, New Employee...). What they want to be able to do is have a search button on the index db that will allow them to search the other 8 dbs to see if an employee has a record created in any of the dbs. If they do, then they would like to be able to see which dbs the employee is in. I tried writing a script that would copy the employee number and then call an external script in each of the dbs. Then enter find mode and paste the employee number into the corresponding field and perform a find. I then returned the results using a similar tactic by capturing the currentFindCount in a field and copying that then pasting it back into the Index db. I would then recopy the employee number and do the whole thing over again for each file. It worked the first time I ran it but after I closed the dbs and reopened them the next day, the copy and paste functions got messed up. I really didn't want to use this approach but I didn't have anything else. Does anyone have any ideas for me? Do I need to go through and create some relationships inorder to accomplish this?

Thanks for any help you can offer!

John

Sorry for the long post.

Share this post


Link to post
Share on other sites

Hmm, seems like an overly complicated system to me. Any possibility of combing those databases into a single EmployeeRecord.fp5 database? Your life would be made much easier.

Otherwise I migh suggest displaying a screen in the "IndexDB" which shows a portal to each of the other DBs by a user entered Employee number.

Share this post


Link to post
Share on other sites

Relationships is the way to go. You would then have a lot of power at your disposal without having to copy/paste/run scripts/jump around all the databases.

With the Relationship, as soon as you choose your Employee and set the Employee's ID (Primary Key), all the data from the other databases would be instantly available.

Use the IsValid calculation function to determine if the Employee has any records on the other end of the relationship. (Foreign Keys).

Then you can create some fancy dynamic statistics such as Counts, Sums, etc.. all from within the Index File.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    Daemon 
×
×
  • Create New...

Important Information

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