Can't type in txt field after join 2 tables.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

SELECT Clients.[FirstName Father], Clients.[ClientCaseID#] AS
[Clients_ClientCaseID#], NotesTable.[NotesID#], NotesTable.[ClientCaseID#] AS
[NotesTable_ClientCaseID#], NotesTable.[Notes Text]
FROM Clients INNER JOIN NotesTable ON Clients.[ClientCaseID#] =
NotesTable.[ClientCaseID#];
Everything works ok until I try to join the 2 tables then I cannot enter
data in the notes text memo type field.
I have tried every relationship combination.
Need this for law firm where I work. Want to put command button on main form
so attorneys can enter notes in this notes form
Please HELP.Thanks. Joan
 
No. It is the # assigned to each case, but can't be unique because I
sometimes have multi-party law suits (cases) that each need the same
ClientCaseId#. It (cases) is my primary table.
I have over 200 cases in the database so it may be too late to add a primary
key such as RecordID -Auto Num. What do you think?
Duane Hookom said:
Is ClientCaseID# a primary key or unique index in the table Clients?

--
Duane Hookom
MS Access MVP


JoanOC said:
SELECT Clients.[FirstName Father], Clients.[ClientCaseID#] AS
[Clients_ClientCaseID#], NotesTable.[NotesID#], NotesTable.[ClientCaseID#] AS
[NotesTable_ClientCaseID#], NotesTable.[Notes Text]
FROM Clients INNER JOIN NotesTable ON Clients.[ClientCaseID#] =
NotesTable.[ClientCaseID#];
Everything works ok until I try to join the 2 tables then I cannot enter
data in the notes text memo type field.
I have tried every relationship combination.
Need this for law firm where I work. Want to put command button on main form
so attorneys can enter notes in this notes form
Please HELP.Thanks. Joan
Click to expand...
Click to expand...
 
I don't think it is ever too late to make a change in table structure to
make an application better.

--
Duane Hookom
MS Access MVP


JoanOC said:
No. It is the # assigned to each case, but can't be unique because I
sometimes have multi-party law suits (cases) that each need the same
ClientCaseId#. It (cases) is my primary table.
I have over 200 cases in the database so it may be too late to add a primary
key such as RecordID -Auto Num. What do you think?
Duane Hookom said:
Is ClientCaseID# a primary key or unique index in the table Clients?

--
Duane Hookom
MS Access MVP


JoanOC said:
SELECT Clients.[FirstName Father], Clients.[ClientCaseID#] AS
[Clients_ClientCaseID#], NotesTable.[NotesID#],
Click to expand...
NotesTable.[ClientCaseID#]
AS
[NotesTable_ClientCaseID#], NotesTable.[Notes Text]
FROM Clients INNER JOIN NotesTable ON Clients.[ClientCaseID#] =
NotesTable.[ClientCaseID#];
Everything works ok until I try to join the 2 tables then I cannot enter
data in the notes text memo type field.
I have tried every relationship combination.
Need this for law firm where I work. Want to put command button on
Click to expand...
main
form
so attorneys can enter notes in this notes form
Please HELP.Thanks. Joan
Click to expand...
Click to expand...
Click to expand...
 
Back
Top