Hi All,

 

I Have 4 tables

 

1. Button Menus

Field Names	Type	Comments
Button_Name	Text
Button_Highlight	Calculation	Unstored,=If( Dashboard::MenuKey = Button_Name; Globals::Menu_Graphics[1] )
Button_Display	Calculation	Unstored,=If( Dashboard::MenuKey = Button_Name; TextStyleAdd ( Button_Name ; Bold ); Button_Name )

 

2. Dashboard

 

Field Names	Type	Comments
ButtonKey	Text	Global
Username	Text	Global

 

3. Warehouse

 

Field Names	Type	Comments
constant	Calculation	1
MATERIALS ID MATCH FIELD	Text	Indexed, Auto Enter-serial ; Cant Modify
Material Receiving Number	Number	Auto Enter-serial
Material Name	Text	Indexed
Material Lot Number	Number	Indexed, Auto Enter-serial ; Cant Modify

 

4. Globals

Field Names	Type	Comments
Sorting_Icons	Container [3]	Globals
Menu_Graphics	Container	Globals

 

Relationships

 

Button Menus x Dashboard ( Button_Name ; ButtonKey)

Dashboard x Warehouse  ( Username ; MATERIALS ID MATCH FIELD)

 

I have a portal from Button Menus Table with the following Records ( Add Material ; Delete Material ; Go to List View ; Print ) I want to use them as my Command Menus.

 

Can you please share your expertise on how I do that using script.

 

Please see attached file.

 

Thank you so much.

 

Rose

 

Warehouse Management.fp7

Your sig says your on 13 advanced. Why post a .fp7 file?

You should really get the FMP Training series for 13 and work through it.

Edited September 15, 201510 yr by Kris M

Hi Kris,

Sorry for that. Im at the office right now. I dont have filemaker 13 here.

 

Thanks.

 

like this

Warehouse Management.fmp12

Thanks Alex, works like a charm