L
Ladypep
I have an Access 2003 form that I have created from 5 different tables. I
have also created a button that allows the user to search for the first name
and last name of a record they want to bring up to edit.
For data which I had already entered directly into the datasheet view of the
table, the search works fine. However, I find that if I try to add a new
record using the form, if I don't enter into at least one field from each
table, the search doesn't find the record, but if I go to the table, the
record does exist. If I do fill out at least one field from each table while
in the form, then the search works and I'm able to edit or delete the record.
None of the fields have been designated as required.
This database is for campaign contribution data for a political running for
office. The tables are: Personal Info (name, title, spouse, children),
Address (just street, city, state, zip), Contact Info (Personal phone, fax,
email), Business Info (possible contributors work information - where, type
of business, position, work phone, email, fax), and Campaign Data (Date
Contacted, Contribution, Voluntter hours).
The form contains ALL of the fields on one single form. If I entered the
data using the table to do so, I would have to enter into 5 different tables,
therefore I want to be able to enter on one form and it post to all tables.
I tied all the tables together using the ID number from the Personal table.
Each time a record is entered using the form, even fields left blank need to
be considered a record. For example, if I post a persons Personal info, but
do not yet have their address info, it still needs to post the person's ID in
the Address table and create the record.
I hope this is not too confusing and that somebody out there will have some
idea. I'm not very good with Access, so I mostly just wing it as I'm asked
to create these databases.
Thanks in advance for any help, suggestions, or ideas.
Sherry Akins
have also created a button that allows the user to search for the first name
and last name of a record they want to bring up to edit.
For data which I had already entered directly into the datasheet view of the
table, the search works fine. However, I find that if I try to add a new
record using the form, if I don't enter into at least one field from each
table, the search doesn't find the record, but if I go to the table, the
record does exist. If I do fill out at least one field from each table while
in the form, then the search works and I'm able to edit or delete the record.
None of the fields have been designated as required.
This database is for campaign contribution data for a political running for
office. The tables are: Personal Info (name, title, spouse, children),
Address (just street, city, state, zip), Contact Info (Personal phone, fax,
email), Business Info (possible contributors work information - where, type
of business, position, work phone, email, fax), and Campaign Data (Date
Contacted, Contribution, Voluntter hours).
The form contains ALL of the fields on one single form. If I entered the
data using the table to do so, I would have to enter into 5 different tables,
therefore I want to be able to enter on one form and it post to all tables.
I tied all the tables together using the ID number from the Personal table.
Each time a record is entered using the form, even fields left blank need to
be considered a record. For example, if I post a persons Personal info, but
do not yet have their address info, it still needs to post the person's ID in
the Address table and create the record.
I hope this is not too confusing and that somebody out there will have some
idea. I'm not very good with Access, so I mostly just wing it as I'm asked
to create these databases.
Thanks in advance for any help, suggestions, or ideas.
Sherry Akins