Club officers record

Discuss the database features

Club officers record

Postby jillmobley » Thu Feb 23, 2012 7:27 pm

I am trying this again. The first time I tried it, two years ago, I got close to getting my many_to_many working. Then, the unthinkable happened, my database was corrupt, but I did not know. I saved over the top of my backup copy. Ack.

I am trying this again. I had the two databases with member names, offices, committees. I can not figure out how to add the year the position was held. Most years, members are on more than one committee.

Thank you in advance for any assistance. I know this seems easy for most, but I just can't get it!

Jill
OpenOffice 3.3 on Windows 7
jillmobley
 
Posts: 21
Joined: Tue Feb 23, 2010 12:30 am

Re: Club officers record

Postby RPG » Thu Feb 23, 2012 9:12 pm

Hello

Learn from this thar one copy is not always enough. How more important the data is how more copies you must have.

Romke
LibreOffice 6.1.5.2 on openSUSE Leap 15
RPG
Volunteer
 
Posts: 2170
Joined: Tue Apr 14, 2009 7:15 pm
Location: Netherlands

Re: Club officers record

Postby jillmobley » Thu Feb 23, 2012 10:07 pm

I understand that one is not enough. I had two copies, was happy with my progress, and saved over the top of my backup as well as my working copy. I did not know the database was corrupt. I have (of course) learned my lesson. Thank you for your thoughts on backups.

I am back to trying to figure out many-to-many. I may not be able to get Base to work for me as I am new to the world of databases. It seems like the perfect application to manage this information.

I am hoping somebody here will assist me with the design.

Than
OpenOffice 3.3 on Windows 7
jillmobley
 
Posts: 21
Joined: Tue Feb 23, 2010 12:30 am

Re: Club officers record

Postby RPG » Fri Feb 24, 2012 1:43 am

Hello

I have no idea about how to help you. I think read your old threads. Or make your question more clear

Romke
LibreOffice 6.1.5.2 on openSUSE Leap 15
RPG
Volunteer
 
Posts: 2170
Joined: Tue Apr 14, 2009 7:15 pm
Location: Netherlands

Re: Club officers record

Postby jillmobley » Sat Feb 25, 2012 4:02 am

I am trying to keep track of club officers, and the years they held the offices or offices and the members that held those offices and what years they held the office.

For example-

Ideally, I could produce a couple of reports:
A report with all the presidents for each of the last few years
A report with all the offices held for a given member for the last few years

This club has typical officers - president, vice president, secretary, treasurer as well as several committee chairmen.

I hope this makes it more clear.

Jill
OpenOffice 3.3 on Windows 7
jillmobley
 
Posts: 21
Joined: Tue Feb 23, 2010 12:30 am

Re: Club officers record

Postby DACM » Sat Feb 25, 2012 8:31 pm

Attachments
Club_Records.odb
n:m (many-to-many) demo
(44.3 KiB) Downloaded 172 times
Last edited by DACM on Mon Apr 09, 2012 4:24 am, edited 1 time in total.
AOO 4.1.x; LO 4.2.x; Windows 7/8 64-bit
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria
User avatar
DACM
Volunteer
 
Posts: 1138
Joined: Tue Nov 03, 2009 7:24 am

Re: Club officers record

Postby jillmobley » Thu Mar 01, 2012 6:17 am

This is a great help. I am working on it, am sure I will have a couple more questions.
OpenOffice 3.3 on Windows 7
jillmobley
 
Posts: 21
Joined: Tue Feb 23, 2010 12:30 am

Re: Club officers record

Postby jillmobley » Thu Mar 01, 2012 6:17 am

This is a great help. I am working on it, am sure I will have a couple more questions.
OpenOffice 3.3 on Windows 7
jillmobley
 
Posts: 21
Joined: Tue Feb 23, 2010 12:30 am

Re: Club officers record

Postby jillmobley » Thu Mar 01, 2012 7:32 am

Is there a way to insert a page break after a group?
OpenOffice 3.3 on Windows 7
jillmobley
 
Posts: 21
Joined: Tue Feb 23, 2010 12:30 am


Return to Base

Who is online

Users browsing this forum: No registered users and 7 guests