Forum Discussion
ForrestParker
7 years agoQrew Cadet
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.
Tables:
- table A
- table B
- Inventory
- Customers
Relationships:
- Inventory has many Table As
- inventory has many Table Bs
- customer has many Table As
- customer has many Table Bs
Tables:
- table A
- table B
- Inventory
- Customers
Relationships:
- Inventory has many Table As
- inventory has many Table Bs
- customer has many Table As
- customer has many Table Bs