I'm probably doing something very strange...
I have three tables:
1) A Client table with a registration number, last name, first name, demographic info (City, State, Zip, etc).
2) A Testing table which tracks the results of our testing process.
and
3) A session table, which tracks information on an individual session.
What I need to do is make a form where my admin can "add" a session or Test to the latter two tables. The problem is currently we are an all-paper company, and so if this becomes too difficult, they simply won't use it (we spent two weeks last month just recovering bad records because one of the admins liked my previous dataase, but the other hated it and didn't enter data into it...)
so, I need to get a clients ID#, Last Name and First name pre-entered on the form that will append data to the Testing and Session tables.
IE.
Admin opens database,
Searches for "Timmy Test"
Brings up Timmy Test's records with blank fields for "Trainer" "Session Date" and "Session time"
Admin enters only "Trainer", "Session Date" and "Time" and then hits "Append"
Then ID number, Last name, first name, Trainer, session date and session time are all appended to the Session Table.
I'm using Access 2000 (for the time being- our company is SUPER cheap), and I am pretty familiar with Access, but not VB programming (I know how to use the GUI interface version of Access)- so if it requires some form of "select" query, I'll need some hand-holding in order to know what field to put it in on the GUI...
I'm willing to haunt these forums and help others out in the future if I can... Thanks in advance!
---Aabh