-
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!
-
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.
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules