Page 2 of 2 FirstFirst 12
Results 16 to 23 of 23
  1. #16
    Thomasso is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Nov 2016
    Location
    Czech Republic
    Posts
    250
    Quote Originally Posted by Bob Fitz View Post
    In post #8 you said:

    How will the InvoiceID be asigned?
    Well, by selecting the tax document in the subform I thought :-)

  2. #17
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Quote Originally Posted by Thomasso View Post
    Well, by selecting the tax document in the subform I thought :-)
    If you have a form based on tax docs, as I suggested in post #10, then you could use a combo box control on that form to select the appropriate Invoice that it relates to.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #18
    Thomasso is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Nov 2016
    Location
    Czech Republic
    Posts
    250
    Yeah, that's another option I'm considering. Thanks for the tips.

  4. #19
    Join Date
    Apr 2017
    Posts
    1,673
    Quote Originally Posted by Thomasso View Post
    I do have frmInvoiceRows of course, but I don't want to mess it up with Tax Documents. I want to link Tax Documents to invoices itself, not invoice items... ! !
    Then you have to create an additional table and form to specifically register documents attached to invoice. I.e. you have e.g. table tblInvoices, table tblProducts, tblInvoiceProducts, table tblTaxDocuments, and table tblInvoiceTaxDocuments. And the invoices form has 2 subforms - one for invoice products (product rows), and another for invoice documents (document rows).

    Or, as was adviced, you have a invoice FK field in your tblTaxDocuments, and skip the need for additional subform entirely. The only problem with this is, that probably the tax documents are registered much earlier than invoice, so you (or user) has to remember to link the invoice key to tax documents after the invoice is registered. I.e. user registers invoice, then activates tax documents form, locates all documents there to be linked to this invoice, and creates the link for every one of them.

  5. #20
    Thomasso is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Nov 2016
    Location
    Czech Republic
    Posts
    250
    Thank you, I actually thought of the junction table as well, but I thought it was a bad database design, trying to represent a 1:N relationship as a M:N. Or is this a reasonable thing to do? Maybe all I need to do is limit the number of entries in the junction table via code.

  6. #21
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Please review the attached sample.

    Cheers,
    Attached Files Attached Files
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  7. #22
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    @Thomasso: have you had a chance to review the sample I uploaded, does that answer your question?

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  8. #23
    Thomasso is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Nov 2016
    Location
    Czech Republic
    Posts
    250
    Hi Vlad, sorry for replying so late, I am a bit busy.

    Yes, this works well for me, thank you very much! :-)

    Tomas

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Multiple Items Form grouped items
    By Tuckejam in forum Forms
    Replies: 2
    Last Post: 04-29-2020, 10:00 AM
  2. Replies: 1
    Last Post: 10-01-2015, 10:02 AM
  3. Replies: 4
    Last Post: 08-19-2015, 08:32 PM
  4. Replies: 18
    Last Post: 01-27-2012, 12:53 PM
  5. Replies: 2
    Last Post: 09-30-2011, 04:57 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