How do you hide the other related DBs?

[dbman]

What am I missing? I am running three related DBs on Win NT/FMP Server.

The parent DB Invoice Master diplays customer info and the items,cost codes and costs are displayed with a portal from DB Invoice Cost Records (ICR).

ICR is related to DB Cost Codes, where the short codes i.e. P-S, P-AS.... are associated to specific dollar amounts.

Problem: When a user selects Invoice Master it opens the other two DBs which are viewable to the user (yes, they are initially hidden from the Host list using "multiuser-hidden"). I do not want the user to dink with these two DB's. Is there a way to keep them hidden? When I tried putting a few user restrictions on certain child DB fields the parent DB fileds would not operate properly.

I hope I've provide enough info, thank you for any assistance.

[Tokyo-B]

If I remember correctly , I think you have to put an underscore at the end of the name. i.e. mydb_.fmp

This should prevent it from displaying...

(Someone please correct me if I am wrong)

Good Luck!

[ January 04, 2002: Message edited by: Tokyo-B ]

[dbman]

quote:

---

Originally posted by Tokyo-B:

If I remember correctly , I think you have to put an underscore at the end of the name. i.e. mydb_.fmp

This should prevent it from displaying...

(Someone please correct me if I am wrong)

Good Luck!

[ January 04, 2002: Message edited by: Tokyo-B ]

---

[dbman]

Thank you for the solution, I give it a try after meetings end this week.

MT

[Thom]

On the files that you don't want users to manipulate directly, make one layout that has no fields on it. You might put a message, like "No user serviceable parts", or something. Set document preferences to start on this layout. Under "Set Layout Order" remove all layouts from the menu. Make sure the user password does not allow designing layouts. Also set the Available Commands to None.