ContributionsMost RecentMost LikesSolutionsRe: 1 to 1 relationship with multiple tablesType A products are what I would call a "mother" and require a tag. Type B products start as a small part of a "mother" and are processed/built from there, but also require individual tags, as well as the ability to determine which "mother" tag/Type A product it originated from. Hope that helps clear it up ------------------------------ Sohum Shah ------------------------------ Re: 1 to 1 relationship with multiple tablesHi Ivan, Unfortunately, I don't think they can. Type B products are created from Type A products so there is a 1-M parent-child relationship between those tables. ------------------------------ Sohum Shah ------------------------------ 1 to 1 relationship with multiple tablesI have 3 tables: Tag Library - A table containing barcode information for thousands of pre-printed tracking tags Item Type A - Table of type A items which will be tagged using tags from the Tag Library Item Type B - Table of type B items which will be tagged using tags from the Tag Library Once an item (either type) is assigned a barcode tag, the Item Type table will have a "Tag Number" field which will contain the human-readable version of the barcode from the tag (using the "Get this field's value from a lookup field and don't allow the value to change" in the field settings) Each tag can be used only once. So, if a tag is used on a Type A item, it cannot be used again in the future, and likewise for Type B items. I have done some research and determined that I will likely need a join table, but the example I saw only has 2 tables, so I am having a little trouble trying to figure out how to set up the relationships and configure the join table. Thanks in advance! ------------------------------ SJS ------------------------------ Bulk Create variable Children from New Parent RecordI have a parent table of barcodes (alphanumeric - NNN#####################), each of which represents a number of child records. The number of child records is determined by manual count and entered as a numeric field in the Parent table. This number may vary from 1 to 500 (maybe more). Each child record will need a new barcode as well. I will be preprinting barcodes in ascending order with the first 3 (NNN) being a preset combination of numbers and letters and the rest being a number starting with 000000000000000000001. I have created an intermediary child "batch" table which uses a beginning barcode number (scanned into field) and the number of barcodes in the child batch to create the ending barcode number. I would like to automatically generate all of the children barcode numbers in different records in the child table when the new 'batch' is entered in the intermediary table. All of the fields will be the same as the parent record, with the exception of the child barcode number. I have created a field which takes the numeric part of the barcode and converts it from text to a number. If I can get the child records to populate with this number increasing by one for each record, I can recreate the barcode number in the child table using a formula field. Thanks in advance! ------------------------------ Sohum Shah ------------------------------