Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Starting Out Correctly

Topic Labels: Base design
283 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I am creating our first database (workspace) and I really need help to design things appropriately. The PRIMARY data we track relates to individual condominiums. The owners of those condominiums change periodically and we need to associate “current” and
former" owners with each unit. We also need to track maintenance items for each of the units.
I want to make certain that I set up “linked” records correctly if that’s the approach I need to take.
Please help if you can. I have already spent an enormous amount of time setting up at workspace on our site called"Pelican Workspace."

1 Reply 1

You could create an [Ownership Log] table which as a field for owner name, a link to a condominium, start date, and end date. Then in your [Condos] table you could have a Lookup field pointed at the [Ownership Log] table’s {Name} field and set it to only show records where {End Date} is empty to show the current owner’s name.