Add same field in 2 or more tables

  • 0
  • 1
  • Question
  • Updated 11 months ago
  • Answered

I have 3 tables created, every table has different fields. At the moment I want to add the Field Costumer or Inventory that is located in Table(A) with the information is saved in that field by the way the field is multiple choice and put it in the Table(B) so every time I opened either is table A or B the information on the Field appears in the form.
Thanks a lot for the help
Photo of Carlos Robinson

Carlos Robinson

  • 90 Points 75 badge 2x thumb
  • Normal

Posted 11 months ago

  • 0
  • 1
Photo of Forrest Parker

Forrest Parker

  • 1,332 Points 1k badge 2x thumb
Hi Carlos. If I understand correctly, you have a customer and inventory field in both of your tables and both of the fields are a text multiple choice field type. Since you want to have those fields in multiple tables your best bet is going to be to create customer and inventory tables and then create relationships between those tables to the tables where you want them.

- table A
- table B
- Inventory
- Customers

- Inventory has many Table As
- inventory has many Table Bs
- customer has many Table As
- customer has many Table Bs