How to Flow Non Primary Key data to another form?

Mike_HWG

I have two tables:

Table A:
No.
File Name

Table B:
No.
Table A No.

I would like to introduce a new field to Table B called File Name, which flows from Table A.

So, I tried creating the field "Table A"."File Name" and created the following TableRelation:

A."File Name" WHERE ("No."=FIELD("Table A No."))

This compiles fine, but the field shows no data, and a lookup on the File Name field results in an error.

Is there a way to still do this? My only requirement for the field is that it can be searched on or used in a filter.

Mike_HWG

I should mention that the reason I'm trying to do this is that my real-life tables have a complex populating routine. I know I can simply set the field during record creation, but I'm hoping there's an 'easy button' I don't know about

DenSter

Make it a lookup type flowfield. Set it to non-editable, so your users don't accidentally change data.

Mike_HWG

Man, I looked right past that about a dozen times! Working great now, thanks

DenSter

Great glad to hear you got that to work