Confirmed - nothing in relationship window
In the Relationship screen under File there is a Print Relationship option
and there is nothing to print.

Regards
Grant


"Eric Butts [MSFT]" wrote in message
...
Hi Grant,

Have you checked the tables relationship within the Relationship window
(Tools Relationship). I would suspect that the field you are trying to
change is used within the Relationship window. Thereby, delete whatever
relationship this table has and then close and save your changes. Then
try
to make whatever change you need to make to the field.

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
http://www.microsoft.com/security/security_bulletins/ms03-026.asp and/or
to visit Windows Update at http://windowsupdate.microsoft.com/ to
install
the patch. Running the SCAN program from the Windows Update site will
help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights




--------------------
| From: "Grant"
| Subject: Removing Lookup Field from Table
| Date: Wed, 12 May 2004 04:56:20 +1000
| Lines: 14
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
| Message-ID:
| Newsgroups: microsoft.public.access.tablesdbdesign
| NNTP-Posting-Host: cpe-144-137-163-97.qld.bigpond.net.au 144.137.163.97
| Path:

cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFT NGP08.phx.gbl!TK2MSFTNGP10
phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.tablesdbdesign:79216
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| Running Access XP
| How does one remove a lookup field from a table.
| I have gone into the relationships area and there are no relationships
| visible.
| Go into table design and try to remove the lookup field and get message
have
| to delete relationship before continuing.
| Tried clicking the Lookup Tab in Table Design and changing from combo
box
to
| Text then change field property to text but get same message as above.
|
| Thanks in advance.
|
| Grant
|
|
|