1
(Sorry this is so long, was trying to fully explain the situation) There are two tables that handle information on our clients. Every client has a unique ClientID, and the ClientID is the Primary Key for the records.
I have a query that displays fields from both tables, but while one of the tables, the main one that hold the Contact information has ALL of the clients in it; the other table holds additional, optional information, so does not have a record for every client.
The Join Properties is set for the ClientID/Primary Key to show all of the records from the Contact table, and only the information from the Optional table “where the joined fields are equal”. So if a client does not have a mention in the Optional table, then the cell for a field from the Optional table is blank, but the cell for a field from the Contacts table holds information, since all clients have a mention in the Contacts table.
Ok, here is the problem: I can not type information into one of those blank cells. I though, since the tables are linked by the ClientID/Primary Key, that a new record would be created in the Optional table (the new record having the same ClientID/Primary Key that the rest of the row/record is working off of) and the information typed into the blank cell be stored there automatically.
Instead it is locking the cell, because there is no record in the optional table for that ClientID/Primary Key, so there is no place to store the cells information.
How can I link the tables ClientID/Primary Key together in regards to a Null record? :confused:
