i would like to have an inventory database. 2 forms. 1st for the parts themselves. part #, description, and quantity on hand. 2nd form for transactions. receive a part(s) which adds part with specified quantity, use a part which subtracts it . i have this form with datetime, part number which i want to link to first form and update that quantity, num of parts used or added, why field which has picklist for use, received, transferin, transfer out. i’m not sure how to set up link to type. i would like to take number on hand on first form and update it with quantity changed on second.
Hi Neo,
Can you upload your form template for the Parent form so I can take a look at what you have so far?
To setup a relationship between two forms, just add a Link to Form field to your parent form, then select the child form you want to link to. Choose the appropriate Link Type, such as One to Many, Many to Many, or Join. Please see the Relationships topic in the online user manual for more information about the different options:
https://www.tapforms.com/help-mac/5.3/en/topic/relationships
.
