Staff Database

[Rushhour]

Hi

At times i need to access staff information so i should create 1 staff database isn't it? Is it create itself in a single file? Then whenever i use script to open this particular file and access the staff information??

else all the files need to have 1 staff database in it??? it seems ridiculous...

Thanks a lot on advance

Kelvin

[Kent Searight]

I think your using the word "database" to mean "table". If so, then you likely need only one table for staff information. Then you relate that table to other tables to do things like lookups, calculations, view data from certain perspectives, etc.

[Rushhour]

Hi yeah i mean table~

So i have to create 1 staff table in 1 single file right? When i need it i will just write script to open that staff file and relate the table..?

Hm.. what if in iwp environment? possible to open file? My Filemaker 7 guidebook states 'Not Supported'...

Thanks a lot

Kelvin

[Zero Tolerence]

Don't use Open file, just relate to the Staff file in your file that is using IWP. Enable IWP on your staff file, then, when you open the main file in IWP you'll already have your connection to the Staff table and won't need to open it.

[Rushhour]

Erm how..? sorry i don't udnerstand. I tried to relate to fields in other files but not possible..

[Raybaudi]

File-->Define Database...-->Relationship-->

ADD TABLE icon (the first one on the left/down side

Specify Table--> File-->Add File Reference...

[Rushhour]

Hi Daniele i have figured it out

Thanks all

Cheers,

Kelvin

[Rushhour]

Hi I have a problem..

My travel report form is in 1 file and my staff table in the other file. And I wanted to link/relate them up as i need to extract 'email' from staff.

After user click submit of form it will bring them to a email layout that will prompt them to confirm and send mail. On the layout it will show what will being sent including emailFrom,emailTo,subject and message. And my 'to' field will be extracted from staff 'email' automatically.

What im thinking is to get staff email based on their accountname. As in my travel report, I used 'accountname' field to let users only able to view their own records.

My staff table having staffID, accountname, name, department, designation, emailTo and other email fields.

Some of the fields travel report form have are accountname, name, department, emailTo and other email fields.

Im stuck on this can't get it through, help will be very appreciated.

Thanks a lot in advance

Kelvin

Edited

My staff table having staffID, accountname, name, department, designation and emailTo fields.

Edited January 11, 2006 by Guest

[Kent Searight]

What im thinking is to get staff email based on their accountname.

Use a uniqueID (staffID?) to join your travel report table to your staff table. Using accountname for the relationship is risky and should be avoided.

Anyway, once this is done you should be able to "extract" the information you need easily.

[Fenton]

I think using Get (AccountName), an unstored calculation field, is often used for situations like this. It is a easy way to know who a person is. He is already using a similar method, via record-level access restrictions, to control visibility of records. All that is needed at the other end, in the Staff table, is a field with their account name. Yes, perhaps this opens a small door as far as security goes, but it's pretty common. I don't see how you can easily control record-level access per person without having the account name somewhere.

[Rushhour]

Hi

I relate the staff and report table and fields,

accountname = accountname

email = email

but nothing happened when i goes into my email layout. I have a accountname field in the layout, but email is not extracted from staff table.

What is the problem then..? do i need to do a 'lookup' or 'calculation'...?

and both my files are in the same folder, and if its not will it be affected?

Thanks a lot in advance

Kelvin