stevekos07
Registered User.
- Local time
- Today, 13:35
- Joined
- Jul 26, 2015
- Messages
- 174
Hi. This seems like such an elementary question it is almost embarrassing, but I need to get it right in my mind.
I sometimes need to add a new field into client's database, but I don't want to keep on just adding fields to an existing table. So I want to create a table with a new data field (e.g. tblClientGender) with two fields:
ClientID (foreign key from tblClients, and the primary key for this new table).
Gender (New field).
But when I add this new table into an existing query I can't update the Gender field because obviously the ClientID is not present for each record, so it is not an updateable table.
How to I make a newly created table editable when incorporated into an existing query?
I hope I am making myself clear.
I sometimes need to add a new field into client's database, but I don't want to keep on just adding fields to an existing table. So I want to create a table with a new data field (e.g. tblClientGender) with two fields:
ClientID (foreign key from tblClients, and the primary key for this new table).
Gender (New field).
But when I add this new table into an existing query I can't update the Gender field because obviously the ClientID is not present for each record, so it is not an updateable table.
How to I make a newly created table editable when incorporated into an existing query?
I hope I am making myself clear.