Link supreport and report using calculated field

[RCurtin]

I have a database of drawings and each one has an order number. The order number is something like 67080 22. The first 5 digits tell me what category of drawing it is in and the last 2 digits correspond to the part number.

These are the tables:
tblOrderCategories
orderPrefix
description

tblPartNumbers
partNum
partDesc

tblDrawings
orderNum
drawingTitle
revNum


So in the last table the orderNum is made up of orderPrefix and partNum. In my main report (based on the tblOrderCategories and tblPartNumbers ) I have an unbound field that concatinates orderPrefix and partNum.

Is it possible to use this unbound field as the masterfield to link it to a subreport with the drawings??

I was trying to avoid putting in an extra field in the parts table with the full number as it should be possible to do this without storing that that can be calculated?

Many thanks for your time,
RCurtin.

 

[RCurtin]

Found the answer

Just found the answer to my problem - creating a calculated filed in my query. I didn't know you could do that - that will def be useful.

This is the expression I entered in the field in the design view of the query: OrderNum: [OrderPrefix] & [PartNum]

Hope it helps someone.