Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
No problem,
In the products table set the Key field to be the Product name.
Then make a relationship where 1 Product has Many order lines and make the connection in the right side of the relationship using your formula product name field.
Then lookup the Unit Cost.
I suggest that you then make a snapshot field which would be a numeric field type to freeze the value the lookup.
Here is some help on relationships
https://help.quickbase.com/user-assis...
Here is some help on snapshots
https://help.quickbase.com/user-assis...
In the products table set the Key field to be the Product name.
Then make a relationship where 1 Product has Many order lines and make the connection in the right side of the relationship using your formula product name field.
Then lookup the Unit Cost.
I suggest that you then make a snapshot field which would be a numeric field type to freeze the value the lookup.
Here is some help on relationships
https://help.quickbase.com/user-assis...
Here is some help on snapshots
https://help.quickbase.com/user-assis...