Results 1 to 2 of 2
  1. #1
    KHill is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    8

    Stock Symbol table and Look up data type in related table


    I previously created 2 tables:
    one lists all the stock symbols and company names = SYMBOL
    the second table lists the purchase information for each stock = PURCHASE
    I then created many queries, etc. using this data. Symbol is the key link between the various tables, queries, etc.

    NOW that I understand the lookup wizard in the data type, I would like to change the symbol field in the purchase table to a Lookup field. I, of course, receive a message. I am told to delete the relationship with the other tables. If I remove the relationships and change the data type, can I then replace the relationship with out damaging all the queries and forms?
    thanks,
    K

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Deleting the relationship in the Relationships builder should not impact the queries. Queries can be built even with no relationships established.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 07-02-2012, 10:50 PM
  2. Replies: 2
    Last Post: 10-19-2011, 06:47 AM
  3. Append to SQL table failing on data type
    By tpcervelo in forum Queries
    Replies: 2
    Last Post: 10-13-2011, 12:07 PM
  4. one table per data type?
    By kman42 in forum Database Design
    Replies: 1
    Last Post: 06-05-2011, 03:40 PM
  5. change data type in make table query
    By jgelpi16 in forum Queries
    Replies: 2
    Last Post: 01-26-2011, 09:37 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums