Can I make a "Table view" button?

[lilacpear]

I need to make three buttons that will allow the user to switch between Form view, List view and Table view. I'm using FM 5.5, by the way.

 

Also, I have a relational database that resides on a separate FM file (let's call it "little DB") and that is used within another FM file (let's call it "big DB"). Every time I open "big DB", "little DB" also opens. Is there any way to avoid this? Users won't need to have both files open to enter data and I want to minimize risk of accidental editing of "little DB". How can I stop it from opening?

 

Many thanks,

lp

[Ender]

I need to make three buttons that will allow the user to switch between Form view, List view and Table view. I'm using FM 5.5, by the way.

 

Check out the template files that come with FileMaker Pro. I seem to recall them having buttons at the top to switch between the different views.

 

Also, I have a relational database that resides on a separate FM file (let's call it "little DB") and that is used within another FM file (let's call it "big DB"). Every time I open "big DB", "little DB" also opens. Is there any way to avoid this? Users won't need to have both files open to enter data and I want to minimize risk of accidental editing of "little DB". How can I stop it from opening?

Other files will open automatically if they are needed for a field, value list, sort, or script to resolve. You could use different passwords if you wanted to restrict access to other files, but then the users will get annoying password dialogs popping up when the resources in those files are needed. You might just limit access in those other files to a blank layout, and use buttons attached to scripts to navigate into them based on some condition.

[lilacpear]

I opened all the template files I could find, but none has a "table" view.

[Ender]

I don't have FM5.5 handy right now, but see if there's a Registration template in there. That might have the table option for the Contacts section.

 

The method just requires a View As [Table] script step, and the layout's Layout Setup->View->Properties changed to include the Header part.