I am creating a Purchase Order and need help to set up a relationship.
I have an Excel file of ‘Suppliers’.
This Excel file has suppliers’ info plus supplied product information such as product name and pricing etc.
I would like to select ‘New Purchase Order” and select the supplier from a drop down box and have all the information related to that supplier appear in their fields. (Address etc.)
In this Purchase Order I have two Tables; Purchase Orders (k_ID_PO) and Line items (kf_ID_PO).
I have set the relationship between these two.
I just created another Table called ‘Suppliers’ where I can import the suppliers Excel file.
This is where I stopped to ask for advice.