Mr. Moulton, I am aware of compatability problems between Access 97 and 2000, and I agree entirely that keeping to one version would make life much easier. I hear your final point loud and clear. there's no ashamed smiley - if there was place it here

There has been some discussion between myself ...

LAC

To answer your question.
Yes, I can save the DB from 2000 into 97 and then pull the data back across at a later date.

To all,
Len's reviewing the first cut of the DB now, or will be shortly. Hopefully we can begin entry soon.

With Repect

[This message has been edited by Socrates (edited ...

I have to smile. The collection of talent that is popping out of the woodwork. http://www.xpres.net/~gmattson/ubbs/smile.gif

I am currently programming in ASP myself and can do some things in it, and given time can figure out more. I have emailed Len and I was going to check out MS Access ...

Mr. Glasheen and Mr. Rose - I have sent an email to Mr. Testa to begin things rolling. You make some good points about verifying the data. I have some small experience with HTML and Web Applications but someone more experienced than myself can most likely create an online form than people can fill ...

LAC - Isn't amazing how much easier it is to explain things when you have a whiteboard to doodle on.

To All - I realized upon re-reading my posts that I may have come across as a little flipant. I apologize for that. I saw a topic that I felt I could in confidence contribute to after almost 4 years ...

Bill Thanks.

LAC You are right about KISS, and about sticking to what the goal of this project would be. I'm not quite sure what you are asking about the table structure I'm typed above but let me elaborate a little. I imagined the Person table as being both students and teachers. There would be ...

LAC
You don't need to excuse anything. I was having difficulty trying to explain it myself. This is one of those things that is easier to do in person, and in front of a computer. In fact looking back on my original post I got some minor confusion in my own head between Oracle DB's and MS Access ...

Hmm... I can't edit the message. It dropped my tablenames out because I stuck them in tags. The tablenames should be Person, Person_Rank, Person_Teachers, Rank_Desc, Org_Desc

Being a programmer I couldn't stay quiet on this one.

I see 3 tables.
Format is Tablename -> Fields

Table 1 <Person> -> ID, Name, Address, Phone, Email, Date_Started, IsTeacher(y/n), Date_started_teaching

Table 2 <Person_Rank> -> ID, Rank, Date, Organization

Table 3 <Person_Teachers> -> ID ...