Skip to main content
Question

Solution to add data at certain amount to another table

I have a procurement table and asset table. There is price field on procurement table. The idea is if the price is more than 2000 USD, it will be included on asset table. Right now, I only have asset table but still thinking about what field for the asset table since the idea is just to put item with price more than 2000 USD on the table

Many thanks, really appreciated
    This topic has been closed for replies.

    Forum|alt.badge.img+14
    You can do this very simply with a QBAction to create the Asset record when the Procurement table record is added; with the condition that the Price field is equal to or greater than 2,000.  You can populate the fields you need with the data values from the Procurement table.
    Laura Thacker | laura@intelligentdbs.com | (626) 771 0454
    I agree with Laura above..In case you don't need to insert entire record in the Asset table, you can use automated action to update a certain field with the USD amount for a particular record..
    Terms & ConditionsAccessibility statement