help around unstored calculation

[Jimbojames30]

Hi,

 

Can someone help me out if they know a way around creating a relationship on an unstored field,

problem is i am scanning barcodes onto a table i have 2 types for barcode GS1 and HBIC, gs1 is cross referenced against another table which matched the number scanned and returns the product code, the hbic is extracted by a calculation

 

i have a filed with an if statement which joins both the gs1 and hbic as i need a one field which contains the product code so i can create a relationship but its unstored and i cannot click on storage because it references a related field? (thats the error i get)

 

 

anyone have any advise?, many thanks

 

[Jimbojames30]

I found a work around, its not pretty but it achieves what i need and thought id post it just in case any one else is looking at this problem

 

i created another field called ProductJoin and created a script and placed it in the on exit trigger where i scan, so once i scanned my barcode it copies the calculation field [Product] and pastes it in the [ProductJoin] field,

 

not pretty i know but i can create a relationship on it, 

[bcooney]

Perhaps another method would be to use Find, rather than a relationship.

[comment]

I don't understand the original description of the problem. What exactly is the unstored calculation calculating?