Hi there, I have created a relationship in aN Access database using the Lookup Wizard which seems to work just fine. The problem I do have with it that once you do create the relationship, it changes the text field to a numeric field. This is causing problems with the website that draws information from it. The field "somehow" needs to stay as text. Is this possible, or is there another way to create the relationship without the wizard?

I have tried creating the two tables and then going in to the Relationships
and joining them there just by draging and droping, but I dont think that is
the correct way. This is becuse when I look up the table with the
relationship it shows nothing.

If it helps I have the following database.

tblSupplier
idSupplier (AutoNumber)
SupplierName (TextField)
SupplierAddress (TextField)
etc

tblCategory
idCategory (AutoNumber)
CategoryName (TextField)

tblSpecies
idSpecies (AutoNumber)
SpeciesType (TextField)

I am trying to bring all the results together in tblUpdateForm.

tblUpdateForm
idUpdate (AutoNumber)
SupplierName (TextField)
CategoryName (TextField)
SpeciesType (TextField)

Relationships I tried to create.

tblSupplier SupplierName (TextField) with tblUpdateForm SupplierName
(TextField)
tblCategory CategoryName (TextField) with tblUpdateForm CategoryName
(TextField)
tblSpecies SpeciesType (TextField) with tblUpdateForm SpeciesType (TextField)

TNX

Mally

Actually it does not change it to text, but to make it easy to deal with it shows you the text value instead.
If you don't want to have it that way. Don't use the lookup wizard but the
Relationships option in MS Access. There you can make your relationships without te problem you face now. Just add the tables you want to relate and drag and drop the items that need to have the realtionship. A line will appear showing the Rel. The you can set if you want it one to one , to many or if you want to enforce integrity and so forth.



Javier

Hi there, i have tried to do it manualy but keep on getting the following error mesage when trying to enforce.

"No unique index found for the referanced field of the primary table".

TA

Mally