Displaying data in lookup table?

[Guest]

Here's some newbie questions that are slowing me down this weekend. I have a
form used for displaying information based on a query using tblApplication
and tblPerson. How do I get the form to display the name of the
ReferringAgency? How would I setup the query for my form?

tblPerson - (one side of a relationship to tblApplication)
PersonID - autonumber
PersonName - text

tblApplication - (many side of a relationship with tblPerson)
ApplicationID - autonumber
PersonID - long integer
Date - date
ReferringAgencyID -text

tlkpReferringAgency - (not related to any tables)
ReferringAgencyID - autonumber
ReferringAgency - text
Active - Y/N

I noticed that in the table tblApplication I have the ReferringAgencyID as
text. Would this be a problem or should it be a long integer? Would it hurt
to change it now?

 

[John Spencer]

Yes, that is a problem. You do need to change the
tblApplication.ReferringAgencyID to a long integer. Otherwise, you will start
running into problems. Access does its best to make adjustments to field types
when it can, however ...

It should not hurt to change it now, BUT BACKUP your database first. If
changing the field type causes problems, then you can get back to your present
situation and try other solutions to fix the problem.

 

[Guest]

Thanks very much John. I changed the data type to match and now I no longer
get error messages when adding the lookup table to the query the form is
based on. Now I can accomplish what I need. I found several other places in
my database where I used a text type field to contain an ID value that was a
autonumber type. Thanks for your help.
--
TIA
Steve

Yes, that is a problem. You do need to change the
tblApplication.ReferringAgencyID to a long integer. Otherwise, you will start
running into problems. Access does its best to make adjustments to field types
when it can, however ...

It should not hurt to change it now, BUT BACKUP your database first. If
changing the field type causes problems, then you can get back to your present
situation and try other solutions to fix the problem.