A
Aaron
Hi,
I've been teaching myself access on the job out of
necessity, and I've come across a small stumbling block in the forms I
need to create.
Basically, if I only build a form using one table, I can
create new records. If I am using more than one table, I cannot.
Specifically, if I start the form using one table, I can create new
records, and even if I alter the SQL code, changing the fields in the
form, I can STILL create new records. But, if I even so much as add
another table, and not even any fields, I cannot create new records
anymore. I've even tried adding ALL of the fields, using the * option,
from each of the tables, and it doesn't work. I don't WANT to add all
of the fields anyway, but I was willing to make this sacrifice if I had
to).
The nature of the data in these tables is such that I
should not combine them into one table. Basically, some of the data is
user-entered, and the rest is in a joined table that is pulled from a
web-application. I have no control over this web application, so I must
paste the table it gives me into the access database. So, I think I
HAVE to use 2 separate tables. If I don't include both tables, then
some of the fields a user will want to see will not be on the form,
since they are from the downloaded table from that web application.
Is there any way to create this form and still be able to
make new records? What is the problem, anyway?
Thanks!
-Aaron
I've been teaching myself access on the job out of
necessity, and I've come across a small stumbling block in the forms I
need to create.
Basically, if I only build a form using one table, I can
create new records. If I am using more than one table, I cannot.
Specifically, if I start the form using one table, I can create new
records, and even if I alter the SQL code, changing the fields in the
form, I can STILL create new records. But, if I even so much as add
another table, and not even any fields, I cannot create new records
anymore. I've even tried adding ALL of the fields, using the * option,
from each of the tables, and it doesn't work. I don't WANT to add all
of the fields anyway, but I was willing to make this sacrifice if I had
to).
The nature of the data in these tables is such that I
should not combine them into one table. Basically, some of the data is
user-entered, and the rest is in a joined table that is pulled from a
web-application. I have no control over this web application, so I must
paste the table it gives me into the access database. So, I think I
HAVE to use 2 separate tables. If I don't include both tables, then
some of the fields a user will want to see will not be on the form,
since they are from the downloaded table from that web application.
Is there any way to create this form and still be able to
make new records? What is the problem, anyway?
Thanks!
-Aaron