G
Guest
Version: Access 2000
Windows XP
What: Trying to make a vehicle registration and ticket tracking program for
my school
1. For my main registraion form, I have a lot of information that I want to
be divided up and stored in multiple databases. As far as I can tell, my form
will only allow me to add one table as a record source. I can change it to
a query, but this seems to be more for viewing data and not storing it (it
won't let me save it). How do I save my data to multiple tables without
having to use one giant one?
2. We have a lot students to register and I want the form itself to be as
simple as possible. Each student can register three vehicles. Instead of
having to ...may have just answered my own question. I wanted to have all
three vehicles registered on one page. My question was then how do I do I tie
all of those fields back to my table. Each table only opens one record at a
time, so when I enter data on my form for one car, it appears in all three
fields (on the form). Any way to tie the other two fields on the form to the
next two table records? I'm thinking now I should just have a new form pop
up, enter in one car, those fields are saved, continue? clear fields and
enter second car, etc.
3. Table relationships. Originally I had a basic student table with three
fields at the end for each vehicle permit ID. I then had a second table with
permit ID as the primary key and then the corresponding vehicle information.
Each vehicle permit is unique. Now, when I tried to create a relationship
from the permit table back to the student table, I could only relate it to
one of the permit fields. Any way to link it to all three permit fields? I
ended up creating a third table with student ID field and a permit ID field.
I then removed the three permit fields from the student table and just
related the student table to the permit table through the third table.
4. We currently file every ticket we have ina huge filing cabinet and it's
impossible to find anything. I'd like to get away from this by scanning in
each ticket and storing them electronicly. Each ticket has a unique number
and I'd like to store the number in a table and be able to pull up the scan
of each ticket. Is there a way to do this?
Thanks guys.
Windows XP
What: Trying to make a vehicle registration and ticket tracking program for
my school
1. For my main registraion form, I have a lot of information that I want to
be divided up and stored in multiple databases. As far as I can tell, my form
will only allow me to add one table as a record source. I can change it to
a query, but this seems to be more for viewing data and not storing it (it
won't let me save it). How do I save my data to multiple tables without
having to use one giant one?
2. We have a lot students to register and I want the form itself to be as
simple as possible. Each student can register three vehicles. Instead of
having to ...may have just answered my own question. I wanted to have all
three vehicles registered on one page. My question was then how do I do I tie
all of those fields back to my table. Each table only opens one record at a
time, so when I enter data on my form for one car, it appears in all three
fields (on the form). Any way to tie the other two fields on the form to the
next two table records? I'm thinking now I should just have a new form pop
up, enter in one car, those fields are saved, continue? clear fields and
enter second car, etc.
3. Table relationships. Originally I had a basic student table with three
fields at the end for each vehicle permit ID. I then had a second table with
permit ID as the primary key and then the corresponding vehicle information.
Each vehicle permit is unique. Now, when I tried to create a relationship
from the permit table back to the student table, I could only relate it to
one of the permit fields. Any way to link it to all three permit fields? I
ended up creating a third table with student ID field and a permit ID field.
I then removed the three permit fields from the student table and just
related the student table to the permit table through the third table.
4. We currently file every ticket we have ina huge filing cabinet and it's
impossible to find anything. I'd like to get away from this by scanning in
each ticket and storing them electronicly. Each ticket has a unique number
and I'd like to store the number in a table and be able to pull up the scan
of each ticket. Is there a way to do this?
Thanks guys.