Search results

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.

Here is a photo of the form property query showing the relationships between my tables/ query.

Pat Hartman, I have tried that but it made the form "read only". Correct me if I'm wrong, but if I make a query that joins two or more tables together as the form's record source, it will make the query un-editable (or "read only"). Also I'm not really sure what a "join" is. Is that when the...

Ok - I have linked master and Child fields. Now I want to show only one record per owner. How and where do i set the sub query to: top 1?

Hello, I posted yesterday about not being able to edit my form because it was based on a read only query. Now that I have my form edit-able again, I need to show fields from other tables on the form. I made a report with the owner's information. I dragged it onto the form as a subreport...

in design view, I click "add existing fields" in the upper ribbon. In the "field list" box I click "show all tables" then select fields from other tables. I see now that I should only use fields from existing record source only. ugh. I guess I could add subreport to my form to show...