I’ve got a database that organises garments and their production prices.
The garments are divided into ‘Sampling’ and ‘Production’
record 1 will be an order for Garment A - Sampling
record 2 will be an order for Garment A - Production
record 3 will be an order for Garment B - Sampling
record 4 will be an order for Garment B - Production
The price of a production garment is based off the price of what the sample cost to make so its quite hand when pricing a garment to have the price shown from sampling record in the production record.
Is there a way I can get a formular field to figure out if record 1 is dealing with the same garment as record 2 and then populate the price to record 2 because it knows that Garment A = Garment A and record 1 is a sample?