Need help with field data type

[LocalUser]

Hi,
In my database I have the following:

1)Projects table:
- Project ID - Number field (Primary Key)
- Project Name
- Location
- (other fields)

2)Working details: (this table has a form based on it and it's used to enter data by users)
- Project ID (this field has a lookup for the same field in the first table)
- Project Name (this field has a lookup for the same field in the first table)
- (other fields)

My problem is : in the second table, Project Name field has "Number" data type because the relationship between the table is on the Project ID which is number field. I want the Project Name to be "text" data type in the second table.

How can i do that??

 

[Mihail]

The WorkingDetails table (as I write, with no spaces) should be:
WorkingDetails
WorkingDetail_ID (PK - Autonumber)
Project ID (FK on table Projects - Number) As it is now !!!
Other fields

As you can see, you should remove the Project Name field from the second table.

And !!!!!!
DO NOT use spaces in names (no for tables, no for fields, no for forms, controls, reports etc etc)

 

[LocalUser]

I solved it ... Thank you

 

[LocalUser]

Thank you Mihail ...