Recent content by xspdr

Thank you for replying. If there is a Composite Key of: FK1, FK2 1, 21 12, 1 Would this mean I have a duplicate Composite Key of 121, or Access would identify them as two different Composite Keys? (1,21) and (12,1)?

Thank you! Should I make 2 columns on the tblTrade or should I make a third Cross Table? tblCurrencyPair PK, Currency1, Currency2 1, USD, BTC 2, USD, CND 3, USD, CNY If you believe I should do this Cross Table to generate the PK, What is the right way to do it? To auto generate new PKs as...

Hello there. tblCurrency PK, CurrencyName 1, USD 2, BTC 3, CNY 4, CND tblTrade FK?, CurrencyName & CurrencyName 1.2, USDBTC 3.1, CNYUSD Is it possible to have two PK (from the same column) into one FK? MS Access 2013 Thank you

Very nice mate Thank you

Your post up here provides a good solution to what I am looking for. I thought I should have many "many to many" relationships to properly build this data (100% normalized). At first I had 4 junction tables, but then I gave up because it was giving me too much trouble to understand all the...

Thanks for your reply buddy! How would you normalize the last table? (tblTransactions) This is pretty much how my data is been built, but that last table doesn't look righ. There are 4 foreign keys on it. A few days ago I tried a bunch of different juction tables, pks, fks and relationships...

Personal Accounting / Multi-Currency Ledger / Normalization / Relashionship Hello everyone, I need help to normalize this table: h.t.t.p.:// i1070.photobucket.com/albums/u485/rodrigo_regis/AccountingNormalization_zpsdf8071b2.jpg One transaction must have 1 or more rows ("entry lines")...