Recent content by stotan7

What I currently have going is this: A 3 Table relationship: "AR Journal" (posting payments to an account) w/ a 1 to 1 relationship w/ "Claim Info" (contains info pertaining to the account and is basically touched once then used for reference). "Claim Info" has a 1 to many relationship with...

To be very honest, I have no formal training in access. Everything i know I have taught myself. Our business has always just used the tables for data entry because it is familiar to staff members with little to no technical skills (i.e. excel) I have made improvements since i took it over...

So for argument sake lets assume that what I am trying to do has to be done in a table and without the use of forms (becasue its what works for us) in Access 2007. I have a table where my staff records a number of different data fields for accounts. I currently have a 3 table relationship...