Hi, I am just starting to learn Access and have a lot to learn.
I have many suppliers each with their own form and only one form for ordering (call it purchase orders). When one row on the Purchase orders is filled out there is a drop down list at the end with the list of suppliers so when it is ordered we can select the supplier it was ordered from. Once the supplier has been selected in the drop down list I would like it to transfer to the correct supplier form carrying the details in that row, so at the end of the day that form should be blank as everything should be ordered.
Hope I am in the correct section.
Any help would be appreciated.
Thanks.