Announcement

Collapse
No announcement yet.

Master details

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Master details

    Hi
    I have two tables. Manifest and Shipment.
    Every Manifest can have zero or more shipments.
    Each shipment belongs to 0 or 1 manifest.

    Manifests and Shipments are entered separately. So not in a traditional Master/detail screen.

    How can I select several shipments at once and add them to the manifest.
    Something like SC does on the screen Field Positioning.

    I have looked into N-N relations. But this requires a third table, and the this relation is a 0-n

    Thanks
    Andre

  • #2
    I do this when assigning an invoice number to several master records.
    I created a control app that take the input entered and assignd it to a global variable.
    I then have a button on a grid where you can select the records to be processed.
    It then assigns the invoice number to all the records with a check box selected.

    kevin

    Comment


    • #3
      THanks Kevin for your idea, it gave me a push in the following direction
      I make a form with multiple record. The field which should contain the manifest ID I fill it automatically. And I disable all fields. So you can only tick the checkboxes. After ticking the correct records you can click save all items.
      This will do it for now, hopefully the customer likes it.
      Brdgs
      Andre

      Comment

      Working...
      X