Results 1 to 3 of 3

Thread: FK Default

  1. #1
    Senior Member
    Join Date
    Jul 2019
    Posts
    175

    FK Default

    Hi All

    I have a page with a form section (customers) and a grid section (orders) and I have related the form section to the grid section.

    When I click add in the grid Order section, is there a way to default to customer ID in new orders record to the current customer ID in the form section?

    Your advice is much appreciated

    Thanks & Best Regards

  2. #2
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    1,942
    Hi WJ,

    Give a person a fish and they will eat for a day. Teach them how to fish and they will eat every day.

    Step 1 in fishing for an answer: what piece of documentation do you think is relevant to this challenge?

    Hank

  3. #3
    Lianja MVP
    Join Date
    Dec 2012
    Location
    Croatia, Zagreb
    Posts
    1,099
    Hi,

    Your case is similar to example_customnavpanel (customer -> orders).
    When you add a row to Orders grid for customer ALFKI, ALFKI is added.
    Tables are related.

    Study that demo.

    P.S.
    Here is an image explaining demo apps usage of tables:

    Name:  demoappsrelations2.jpg
Views: 22
Size:  79.8 KB
    Last edited by josipradnik; 2020-01-01 at 12:46.

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us