Re: Form using multiple tables not allowing new records

Tech-Archive recommends: Speed Up your PC by fixing your registry


Cyberwolf wrote:

Um, that's how I created the relationships in the first place. This one
comes up as "indeterminate."

I assume it has to do with either the fact that I'm not using a primary
key on either side of this relationship or the fact that there are
entries in the second table that do not match up with entries in the
first table.

-Aaron

Click on Tools> the Relationships. Add the tables you want to create
relationships for, then simply click and drag the field in one table to the
field in the other table you want to join on. Then follow the prompts.
--
Cyberwolf
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf


"Aaron" wrote:


TonyT wrote:
Hi Aaron,

If there is a relationship between the data in these 2 tables, and your can
join them with a relationship of one-to-one or one-to-many, then you can
create a form based on a query that joins the 2 together, and usually this
recordset will be updateable from within your form. (I say usually, because
some Outer Joins create recordsets that cannot be updated, but more often
than not in the case you describe it will be updateable).

TonyT..

Thanks, Tony.

This could be the problem. The relationship is showing up as
"indeterminate," when it really should be one-to-one (with some records
not matching at all). I noticed it before, but didn't know what I could
do about it.

What CAN I do about it? This is one of my few linkages that doesn't
involve a primary key, because these 1800 applications have their own
ID, and it was easier to link the data that way (similar to a vlookup
in Excel). I don't know how to proceed...

-Aaron


"Aaron" wrote:

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





.

Relevant Pages