how do i Automatically link new records entered into a child table (many) to a record in the parent table all within the same app?
I have a parent table with each record containing a barcode and descriptions / pictures of the item.
I have a child table where i will scan barcodes that are in the parent everyday. it would be great if every time i created a record in the child table and scanned the barcode, that the record would automatically link to the appropriate barcode in the parent table.
Is this possible? Thanks very much!
It sounds like you would like your child records to link to a parent record based on a barcode on the parent record. Unfortunately, there is no way for a child record to know what is in an image field on the parent table to base a relationship on. However, if you changed your Record ID to be the code itself, you could scan the barcode in the child's link-to-parent field to establish that connection. Also, keep in mind that if you create child records from the parent record itself they will be automatically linked to that parent.
I hope this is helpful, but if you have any additional questions please feel free to call our Support team 800-673-3302, we would be happy to help!