I was told that using Lookup fields in tables is not a good Idea or proper database setup/Management.
already having had problems using the Lookups in tables I want to understand more how not to use lookups in with related fields in tables
So How do I set up the relation in the tables
If i have a list of accounts in a table, every account has AccountID and AccountName
and in my table of transactions, every transaction has an Account name, so is that linked field AccountID and that field is just a data type number, Long Integer?