Menu Selection Script

[susnhine92122]

I am trying to write a script that does the following:

1. Opens a new window [app selection] layout that has a list of all possible menu items (I have this part figured out)

2.When I click on the arrow next to the item I want another script that takes this item and adds it to the purchase order [apps PO layout]

3. I want to return to my original layout and see the the item I selected in the [apps PO portal]

For the [apps PO] I have a relationship formed using the [color:red]event ID field in the [event management]

I also have a relationship between [apps PO] and [apps list] using the [color:red]Item number field

The [apps PO] has the following fields:

[color:red]item number

item description

cost pp

The [apps list] has the following fields:

[color:red]item number

item description

group

cost pp

I have tried using a script I found in another database and modifying it, but to no avail. Any help I could get would very much be appreciated!!!

[efen]

It isn't clear to me how your tables (only two?) are related. Which are the primary and foreign keys in each file? What is event ID connected to in apps list?

[susnhine92122]

The [color:red]event ID field in Event Management table is connected to the [color:red]event ID field in Apps PO Table

The [color:red]item number is in both Apps PO Table and Apps List tables

[efen]

Is the attached of any help?

menu_items.zip