Skip to main content
Question

1 to 1 relationship with multiple tables

  • February 17, 2022
  • 0 replies
  • 28 views
I 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
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+11
  • IvanWeiss
  • Registered
  • February 17, 2022
Sohum, could the type A/B be a field in lieu of two distinct tables?  It seems to me that you need an Items Table and a Tag Table and those could be related.  You could set a "unique field" on the barcode to ensure it is not used twice.

------------------------------
Ivan Weiss
------------------------------
Terms & ConditionsAccessibility statement