This is probably basic, but I can't figure it out.

I have a table of mineral interest with columns for parcel number, interest owner, and mineral interest percentage.

In the parcels table, I'd like to populate a column ("mineral_interest_summary") with the names and percentage of the interest owners thereof.

E. G. Bugs Bunny (50%), Daffy Duck (25%), Elmer Fudd (25%).

I'll settle for any method to populate this data, but it would be nice to do it with an active column. Can anyone help?

By the way, I'm using v8

it would be better to see an actual table to know exactly how the data is laid out. For example, are the percentages a value in the table, or do you compute them in some fashion? Also, are the percentages a text value that includes the percentage symbol, or a numeric field and then you add the '%' mark?

Anyway, this is a short little query:

UPDATE parcels

SET [mineral_interest_summary] = [interest_owner] 

 &  " (" & [mineral_interest_percent] & "%)"

For an active column, it would be this:

Function Func

 Func =  Record.Data("interest_owner") & " (" & Record.Data("mineral_interest_percent") & "%)"

End Function

An example of your data would be helpful. I assume your table of mineral interest has multiple records with the same parcel id. That is based on the fact that you can have multiple owners per parcel. Post an example, and you can expect some help.

http://www.mppng.nl/manifold/pointlabeler