Hello. I have created a database to keep track of clients and their training requests. I have already created the tables and have some data entered. It is just now that when attempting to create a query with the two tables that I realized I have problems as I am getting a Type Mismatch error.
The first table keeps track of clients. Each client has a unique client number field which is an AutoNumber. The second table is a Training Request table that keeps track of the training requests for each client. Each client may have many training requests. I entered a Client Number field in this table too and that is how the two are linked by relationship. I set the Client Number field in the Training Requests table to be a Text field. I realize they are different data types but I didn't think I could set it to be an AutoNumber in the Training Requests table.
How can I fix this table design? Would I just be able to change a data type? I am very unsure of what route to follow.
Thank you in advance for any help that can be provided.
The first table keeps track of clients. Each client has a unique client number field which is an AutoNumber. The second table is a Training Request table that keeps track of the training requests for each client. Each client may have many training requests. I entered a Client Number field in this table too and that is how the two are linked by relationship. I set the Client Number field in the Training Requests table to be a Text field. I realize they are different data types but I didn't think I could set it to be an AutoNumber in the Training Requests table.
How can I fix this table design? Would I just be able to change a data type? I am very unsure of what route to follow.
Thank you in advance for any help that can be provided.
