Table relationship problem

I think I am having problems with table relationships. Here is what I
have.

Table 1 has Social Security Number
First Name
Last Name
Autonumber
Since I will have many duplicate Social Security Numbers, Autonumber
is the primary key.

Table 2 has Social Security No
Notes

I joined the two tables with an indeterminant relationship using Social
Security Number and Social Security No. I want to use Social Security
No (Table 2) to pull the corresponding name from Table 1.

I built this query:
Social Security No - Table 2
First Name - Table 1
Last Name - Table 1
Notes - Table 2

The query works just as I need it, but whenever I build a form based on
the query, the form will not work. It opens with the error the the
Recordset is not undateable. What does this mean and how do I make
this work?

.

Relevant Pages

  • Re: Query with two tables
    ... The other table's is currently set up with the same input mask, ... "Tom Ellison" wrote: ... Please post the SQL of the query that returns only 50 rows. ... the tables have the Social Security Numbers in common. ...
    (microsoft.public.access.queries)
  • Re: Cannot join on Social Security Num
    ... Open your query in SQL view and try change the Join clause to something like ... Table1 INNER JOIN Table2 ... Security Num, I get zero records ... There are matching Social Security Nums in both tables though ...
    (microsoft.public.access.queries)
  • Re: Cannot join on Social Security Num
    ... "John Spencer" wrote: ... Open your query in SQL view and try change the Join clause to something like ... Security Num, I get zero records ... There are matching Social Security Nums in both tables though ...
    (microsoft.public.access.queries)
  • Re: Cannot join on Social Security Num
    ... Open your query in SQL view and try change the Join clause to something like ... Security Num, I get zero records ... There are matching Social Security Nums in both tables though ...
    (microsoft.public.access.queries)
  • Re: Query with two tables
    ... If you post the SQL view of the query you have and tell me if you want all ... One table is from my database, and the other one is a linked table from ... Both tables have a common number, Social Security ...
    (microsoft.public.access.queries)
Loading