In a Products table I have SKU and Description.
In a Order Line Items table I also have SKU and Description.
When creating new records in the Order Line Items table, there will be instances where the user knows the SKU and instances where the Description is known.
I can create a lookup which looks up the Description from the SKU. I can also create a lookup which looks up the SKU from the Description.
My understanding is that two Table Occurrences are required.
However if the user selected the wrong SKU or description, how can it be edited? The data remains the same, presumably because the two lookups are conflicting?