Results 1 to 6 of 6
  1. #1
    carnut0913 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    3

    Queries as Row Source or Field Lookup and relationships


    1) Novice

    2) Creating a database where I have one table that has all companies; including customer and supplier- sometimes both.
    I have created two queries, one for customers and one for suppliers.

    3) I cannot get the Lookup and Relationship Wizard to recognize queries as a source for a field in a table (Purchases).
    4) I then created a form from the table (Purchases) and used the property 'row source' to select the appropriate query.
    That worked in that it gave me the appropriate query table of companies to pick from.

    But the table will not store the selection.


    2012 Partner Database.zip
    What am i missing?


    thanks!
    Last edited by June7; 04-01-2012 at 11:19 AM. Reason: Mod edit: remove duplicate attachments

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Uh oh web database. I can't open the tables in design view and the Convert to Local Table is not available. I have never built a web database.

    I don't see a Purchases table.
    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.

  3. #3
    carnut0913 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    3
    Quote Originally Posted by June7 View Post
    Uh oh web database. I can't open the tables in design view and the Convert to Local Table is not available. I have never built a web database.

    I don't see a Purchases table.

    quarterly orders table. you can see fields for mftr and distributor.

    I want to tie them to the respective queries.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    I can't get anything into design view so can't analyse problem. What trick do I need to know?
    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.

  5. #5
    carnut0913 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    3
    no trick that I know of?! Icannot seem to either.

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Start from scratch?

    Can you import the objects as normal (non-web) objects into another Access file?
    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. Tables, Relationships, and queries.
    By Andyjones in forum Access
    Replies: 2
    Last Post: 01-22-2012, 05:23 AM
  2. Mail Merge data source queries missing
    By UTS in forum Queries
    Replies: 6
    Last Post: 09-21-2011, 01:48 AM
  3. CrossTab Queries data source to Excel?
    By Shakenaw in forum Queries
    Replies: 0
    Last Post: 07-05-2011, 08:26 AM
  4. One lookup table many relationships?
    By sparlaman in forum Database Design
    Replies: 4
    Last Post: 03-29-2011, 10:28 AM
  5. Creating Relationships and Queries
    By nacho in forum Database Design
    Replies: 4
    Last Post: 04-16-2010, 03:22 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