Removing Lookup Field from Table

G

Grant

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
 
E

Eric Butts [MSFT]

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
(e-mail address removed)
"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" <[email protected]>
| 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: <[email protected]>
| 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!TK2MSFTNGP08.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
|
|
|
 
G

Guest

Also, make sure to scroll up and down, and right and left in the Relationships window to make sure there isn't anything your not seeing. The window is particularly large and sometimes there is a relationship out of your view that you don't realize is there

Corrina Burnle
Burnley Data Solution
www.burnleydatasolutions.com
 
G

Grant

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
 
J

John Vinson

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.

The blankety-blank Lookup Wizard often conceals the relationships it
creates. Two suggestions:

- Open the relationships window, select the table, and choose View
Direct.

- Or, run this small tactical nuclear device, probably with additional
code to limit its damage, and certainly on a COPY of your database;

Sub KillAllRelations()
Dim db As DAO.Database
Dim rel As Relation
Dim inti As Integer
Set db = DBEngine(0)(0)
For inti = db.Relations.Count - 1 To 0 Step -1
Set rel = db.Relations(inti)
Debug.Print "Deleting relation "; rel.Name, rel.Table,
rel.ForeignTable
db.Relations.Delete rel.Name
Next inti
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top