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!!!

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?

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

Is the attached of any help?

menu_items.zip