Hello,
I use dining accounts and cards in my business. Dining accounts can be linked to multiple cards, but each card can only be linked to one dining account. The current requirement is that dining accounts and cards need to be managed separately, as we need to search for dining accounts by name and cards by card number. At the same time, I need to check the bound card in the dining account, and similarly, check the dining account to which it belongs in the card.
I tried to set the card as a sub table so that it can be managed through the table in the dining account. However, this will result in the card being unable to be individually bound to menus and managed.
Conversely, if the card is not set as a sub table, I cannot manage it through the table in my dining account.
I have also tried to create an intermediate table as a sub table to associate cards, but the result is that one card can be associated with multiple dining accounts, but this was not my original intention.
So, how should I fulfill such business needs?
Best regards!