Results 1 to 3 of 3
  1. #1
    getter is offline Novice
    Windows 10 Office 365
    Join Date
    Apr 2020
    Posts
    1

    I need help!

    Hi guys

    I am supposed to organise our company assets and shipping paperwork from Ragic to Access but I can't wrap my head around it.

    Right now I have used the asset tracking template which works semi good for the asset part, but I need to build a Commercial Invoice that would be connected with assets so that it would automatically do utilisation and goods in/goods our forms as well.

    Is this even doable? Help.. please!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Yes,it can be done. Most things can be done with child tables.
    Like an online shopping cart order, you have the master table,tOrder
    that holds: OrderID,date,ClientID

    then the child table tOrderDetail:
    OrderID, ItemNum,Qty,price,Color

    Same with Invoicing, the master details table, and the sub table(child)
    of all the sub records.

  3. #3
    dashiellx's Avatar
    dashiellx is offline Falconer
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Location
    Baltimore
    Posts
    49
    Ragic and Access are very different. Ragic is actually closer to Excel than Access. However, everything you are asking can be done easily in Access once you have the correct table structure.

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

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