Results 1 to 6 of 6
  1. #1
    Aliurz is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2016
    Posts
    1

    Problem with two 1 to Many relation together. WITH SCREENSHOT for better explain.

    I have table with name "Order" when want to select "pay method", it just show a number (Pay_Method_Id). I want it shows name of card.
    i add screenshot for more explain.
    Click image for larger version. 

Name:	Relation.jpg 
Views:	23 
Size:	35.2 KB 
ID:	26192



    Click image for larger version. 

Name:	OrderTable.jpg 
Views:	22 
Size:	54.8 KB 
ID:	26193
    Click image for larger version. 

Name:	PayMethodTable.jpg 
Views:	22 
Size:	35.5 KB 
ID:	26194
    Click image for larger version. 

Name:	CreditCards.jpg 
Views:	23 
Size:	21.2 KB 
ID:	26195
    Click image for larger version. 

Name:	LookUpWizards1.jpg 
Views:	22 
Size:	41.7 KB 
ID:	26196

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    You should avoid lookup fields at table field level. Use Forms to do lookups.

    Update: Solved at http://www.utteraccess.com/forum/ind...ic=2040058&hl=

    Aliruz,
    I realize you are new to the forum, but this is regarded as a good practice on all forums:

    When you cross post, tell readers you have done so and provide the associated link(s).

    Here is why!

  3. #3
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    dang! just wasted 1/2 an hour

  4. #4
    Micron is online now Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Thank you, Orange. You just saved me time. Wish I knew how to catch that without trolling all over the 'net in other Access forums
    A moderator should and should be able to flag a poster name with a small icon when the OP is called out for cross posting so the rest of us can do a little search on the post subject line before wasting time. If no more undeclared cp's in say 6 months, remove it. If repeated undeclared cp's, maybe some stronger medicine?
    Last edited by Micron; 10-21-2016 at 09:58 PM. Reason: afterthoughts...

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Micron,

    Interesting approach. I can assure you that some forums question whether cross posts should even be flagged/noted/identified. Like you and others, I have been a victim of spending a lot of time working to help someone only to find the issue had been resolved on another forum. The OP never goes back to say it was solved; never advises of the solution on any post and sees nothing wrong with the practice of never giving anything back.

    For me it is netiquette - perhaps even common decency and at least a common courtesy - to provide those who willingly volunteer to help with info of the "problem/opportunity" and advise within the post that others have been asked for advice/assistance and give the coordinates.

    I think the Excelguru's article is spot on and important. And I will point cross posters to it when I find such posts. Some real newbies (1 or 2 posts) don't frequent the forum, so a reminder seems appropriate. It just might start them off on a better track.

    Glad you saw the reference before spending time on it (especially at midnight).

  6. #6
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    If repeated undeclared cp's, maybe some stronger medicine?
    In at least two forums (Excel based). Repeat offenders are issued public warnings, and sometimes banished for periods of time. It is a rare case, but I have seen it happen.

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

Similar Threads

  1. Replies: 5
    Last Post: 08-30-2016, 06:53 AM
  2. query with relation in tables problem
    By JeroenMioch in forum Access
    Replies: 4
    Last Post: 04-01-2016, 03:06 AM
  3. Replies: 3
    Last Post: 01-22-2014, 11:31 PM
  4. Replies: 6
    Last Post: 05-24-2012, 11:07 AM
  5. Date not Sorting Correctly (screenshot attached)
    By KrenzyRyan in forum Queries
    Replies: 5
    Last Post: 06-27-2011, 01:44 PM

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