Recent content by ZenDiagram

Mike60smart, I know my database isn't normalized completely but I want to keep it this way. Is there a way to fix this without restructuring my tables?

Hello. I was hoping someone could go into this sample database and help me with a few things. Purpose of the database: to hold data about owner's and their properties. (one to many) That data's sole purpose is to be generated onto a yearly report that goes to each owner. The report is...

I am new to Access and get overwhelmed with the details, sorry if it seemed like I wasn't taking your suggestions. I have studied normalization, but most examples are given for companies that sell things. I know the logic is the same but I have a hard time visualizing normalization for my...

Ok I have made a slight compromise on this. See photo. Fiscal year is going in tblOwnerProperties. It doesn't really matter where it goes so I'll just keep it there. it's only use is on the report. I could just make a label on the report but then i would have to change it every year vs. just...

"You are still storing values in field names. 61, 61A, 61B should never appear in the relationship. Those go in fields as values, not in field names." the 61, 61A, 61B are not the values- those fields are where I store the acres. Here is another version. Also - I should have been...

Okay, take a look at this: Note: there is only one owner and that one owner's mailing address that the report is mailed too. But there could be other owners that are associated with the property(ies).

Also- I am only making a field for the most recent lien. Each property only has one lien and that is the most recent lien recorded for that property.

Ok - Thank you everyone I am trying to incorporate your replies. I have attached a sample database. Could someone go in an further normalize the tables? I am having a hard time envisioning this.

Ok - goods points about the fiscal year. Yes- I am storing number of acres for each tax status in those fields. the field [land classification] is where I put the values 61, 61A, or 61B. SO I could rename [land classification] as [tax status] because they are the same thing. (sorry, synonym)...

No, a property could have one or more tax statuses.

OK - Are these field names looking better?

That's good advice. So- I need two basic tables: TblOwners, TblOwnerProperties. You will see in TblOwnerProperties the fields named "61","61A","61B". Those are the different tax statuses. A single property could have acres in any or all of them. Not sure if this is helpful to you or...

Ok, I have renamed the tables. Here is updated version (attached photo)

I built a database that works pretty well but I'm realizing that my original db table design & relationships were not designed well. I am going back to the basics. I would love some feedback. purpose of the database: keeping track of land owners in a town who have one or more properties...

Thanks so much, Pat Hartman. I will readjust.