Hello,
I have am setting up a new database to track orders.
I have a table containing the product name and also a SKU. When placing an order I want the user to be able to select either a product or a SKU from the list and the other field to be automatically populated with the corresponding product or SKU. At the minute I select a SKU and the product field stays empty.
How can I do this ?
Thanks
I have am setting up a new database to track orders.
I have a table containing the product name and also a SKU. When placing an order I want the user to be able to select either a product or a SKU from the list and the other field to be automatically populated with the corresponding product or SKU. At the minute I select a SKU and the product field stays empty.
How can I do this ?
Thanks