PDA

View Full Version : Database Relationship HELP!


malhyp
05-18-2006, 12:22 PM
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 :?: