Record/Field Relations?

[mKirk]

I have two tables; "TableA" and "TableB". Each table has four fields; "1", "2", "3", "4". What I want to do is...

When I create a new record in TableB, I'd like to do something like this:

TableB/Field1 = TableA/RecordX/Field1

TableB/Field2 = TableA/RecordX/Field2

TableB/Field3 = TableA/RecordX/Field3

TableB/Field4 = TableA/RecordX/Field4

"RecordX" is a specific record in TableA...it never changes. I can get this to work using a series of Go To/Copy/Paste type of scripts, but this doesn't seem to be very elegant and I have the feeling I'm not fully understanding the power of relational dB (I'm new here, remember) and that there must/should be a more efficient way to script this. Thanks in advance for any help.

Kirk

[sbg2]

You shouldn't need to script this. What makes RecordX in TableA unique, perhaps a serial ID? In other words if you needed to perform a find in TableA how would you define the find to return only RecordX?

Create a new GLOBAL field in TableB - g_RecordX_Field1 = "Insert what makes RecordX unique here". Then relate the two tables TableB::g_RecordX_Field1 = TableA::"UniqueField". Now you can use a lookup for Field1, Field2, Field3 & Field4 over this relationship.

[RalphL]

Not quite sure I understand what you want here. But I think what you want can be done with auto-enterd calculations.

It looks like every record would have the same data in these four fields.

[mKirk]

Thanks much...that worked exactly as I had hoped. It was the lookup part of the equasion that I was missing. Thanks again for the assistance.