+2I’m creating a list of property. Each item has one or more owners pulled from a separate table.
I need to be able to add multiple owners for each property and assign a percentage of ownership.
Eg.
Property A is 100% owned by Bob
(owner is pulled from another table but percentage is specific to this record)
Property B is 50% owned by Bob and 50% owned by Jim.
Any ideas?
+2The Stake table uses a formula in the primary field to combine the property name and Owner.
The Stake table is grouped by the Property Linked field so you can see the percentages add up to 100%.
The linked fields in the Stake table do not allow linking to multiple records.
The linked field to Stake in the property does allow linking to multiple records.
What do you think of this approach?
+2That looks like it should work.
Will I be able to create reports based on the ownership percentages? Filter by them? etc?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.