I have limited experience with FM but am not new to data.
How would one go about designing a solution to support a data import workflow (for fields a, b, c) such that fields x,y,z could be assigned values by the user at the time of import?
For instance, using the following fields...
Field a = product id
Field b = qty sold
Field c = price
Field x = customer
Field y = season
Field z = event name
I need to populate an existing FM table such that each row becomes:
product id | qty sold | price | customer | season | event name
Ideally, the values for Fields x, y, z would be entered using a dropdown box which receives its data from tbl.customer or a LOV.
I do appreciate any guidance!