Transferring Data and Double Lookup Help

Transferring Data and Double Lookup Help

I would like to ask how I would do the following actions/codes.

So I have a Budget Request Application where a User needs a request for a specific Project and lists all their needs in a subform via per-item lists. So, for my questions.

1. I have a dropdown field named Project Name (Project_Name), now as we created the app before, we didn't use a lookup instead because we don't have Project Database (in another app) yet. Now that we have it, we are planning to implement the lookup field now but how can we transfer the existing data in the Project_Name dropdown field to the new Lookup Field for existing data?

For Example:
Column:       Project_Name (dropdown      Lookup Field (new)
1.                  Project1
2.                  Project2
3.                                                                    Project 4

how do i transfer records 1-2 to the lookup?




2. Next question, also in the same budget request app, i will also introduce a supplier lookup where they can find a bunch of lookups of supplier stores for easy selecting items in the subform. Currently the supplier is only just a single field, and the item name in the subform is also a single field. I want it so that if i pick a value in the main form Supplier Lookup, the subform of the Budget Request has another Supplier Item Subform Lookup that filters it based on the selected value in the Main Form Supplier Lookup


Thanks